I gang

Match Data and Delete Rows

I have two spreadsheets, one containing a list of all of the audio files that are currently in a large sound effects library that we sell. This sheet I will refer to as the "Master" list. The second spreadsheet contains a list of sound effects that we wish to remove from the master list - I will refer to this as the "Delete" list.

So basically, match the two lists by the "File Name" (Column A in both), and match everything from the "Detele" file to the "Master" file, then delete those rows. It is worth noting that the file names you'll be referencing are formatted a little differently in the two spreadsheets. They have the same basic information, except the file names on the Master sheet contain the characters "DD0," THEN then file name. So on Delete, you'll see "[url removed, login to view]," but on Master you'll see "[url removed, login to view]". Not that crazy.

The end result should be 16,356 rows of data.

This seems pretty simple, I just can't write macros for Excel! I need this done no later than Thursday, March 31.

Thanks!

Færdigheder: Dataindførsel, Databehandling, Excel, Microsoft, MySQL

Se mere: sell excel spreadsheets, match list, delete rows spreadsheet, master audio, rows, match, master data, large data, delete, audio master, macros excel basic, remove characters excel, need match files excel, audio data entry, large excel macros file, spreadsheets macros, basic information spreadsheets, need excel macros, master excel sheet, library need data entry, data entry library, library data entry, excel data match, excel rows, list match

Om arbejdsgiveren:
( 1 bedømmelse ) New York, United States

Projekt-ID: #1001898

Tildelt til:

dataconsultants

Please check PMB for details, Thank you

$30 USD på 1 dag
(102 bedømmelser)
5.8

3 freelancere byder i gennemsnit $30 for dette job

dataexpobd

Please check PMB

$30 USD på 1 dag
(51 bedømmelser)
5.6
thusnani

Hi, I come with 3 years of experience building macros. I currently build them on a weekly basis at my current position. I can complete this task in less than an hour for you. One question is how you want to execute Mere

$30 USD på 1 dag
(0 bedømmelser)
0.0