Finding and Replacing Data in a Header Row

H

Hans Hamm

I download an excel file from an outside source (which I have no control over the what columns, rows that are or, are not included)... raw data. There can be 60-120 columns of data. Row 1 Contains the Headers.
The raw data is on Sheet 3, row 1...

EXAMPLE: Column AM, the project name is; "D26B Faucets (Rollout) [000000419]",
There can be anywhere from 10-30 projects listed in Row 1
I have a Project List on Sheet 4 Column N which will contain "D26B Faucets" and as many as 10-30 projects

WHAT I NEED: is the most efficient and effective way to replace the Project Names on Sheet3 with those names on Sheet4.

Any ideas would be appreciated!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Help 1
Eliminate blanks while copy row and transpose 11
Delete duplicate rows without deleting entire row 1
vba code to filter the data like a group with group header 5
filter function 0
Find and Replace 6
Macro Challenge – Create Table with Hours Worked and Copy Data 0
Mail Merge query 1

Top