PDA

View Full Version : Compare ID and Header Two Worksheets



had1015
08-11-2016, 09:46 AM
Hi,

I'm trying to create a macro that will compare two sheets in one workbook. On both sheets there are multiple columns of data, however sheet2 has many more columns of data that's added each day. I would like to be able to look at the ID number which will always be in column F on both sheets. When there is a match I would like to then look at column header names for a match. I'd like to look for "SVD" on both sheets. When both those criteria are met, I would like to copy the data for each matched ID starting at "SVD" column for 21 adjacent continuous cells to the right from sheet1 to sheet2. I've tried searching several places for several days and forums for this answer but can't find help. Any of your expert assistance would be greatly appreciated.

DH

xavier73
08-12-2016, 12:03 AM
Can you place the excel file to see what you mean.

had1015
08-12-2016, 01:35 PM
Thanks for answering Xavier I have to get my file from the office. I will have it soon.