M
Marie
In microsoft excel 2003, I frequently compare info from different
workbooks/worksheets. I have large databases and going line by line is long
and tedious. I need to create a macro that can cross-reference between two
sheets/books and copy information in one column to the same column in the
next sheet in which the correlating row is the same. ie: info in a1.sht1 =
a1.sht2 therefore copy info from d1.sht1 to d1.sht2 for all rows in sht2 that
match sht1.
workbooks/worksheets. I have large databases and going line by line is long
and tedious. I need to create a macro that can cross-reference between two
sheets/books and copy information in one column to the same column in the
next sheet in which the correlating row is the same. ie: info in a1.sht1 =
a1.sht2 therefore copy info from d1.sht1 to d1.sht2 for all rows in sht2 that
match sht1.