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
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