$%Macro to Copy from one workbook to other when matching data

T

Tiger

I am trying to develop a macro that copies data from one workbook to another,
however looks up the date in wb1, then finds the same date in wb2, and copies
values from wb1 beside the matching date in wb2

e.g. wb1 date 07/07/2007 ,wb2 (monthly report, dates from 1/07 to 31/07/2007
in a column) When macro runs, looks up date in wb1 and then copies data from
wb1 to wb2 if if finds same dte in wb2, otherwise says no data to update,

can anyone help???
Thanks Tiger
 

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

Top