Hey, I need some help. I have a Report that I run at work in excel.
It
has multiple sheets, each one corresponding to a specific product. I
am pulling the same type of data from Access for each sheet. Instead
of running a query for each sheet, I was able to put together a macro
in Access to dump all the data I needed in a new workbook with an
extra column for product ID. The product ID can be in one of two
formats for each product. I need to write a macro that would read
each
of the 2 IDs from the top of each sheet in my workbook, compare it to
the IDs in the other workbook, and if they are the same it needs to
copy the data and paste it to the sheet with the corresponding ID.
This would effectively update my entire workbook. Can anyone help me
with this? Thanks.