$%Macro to Copy from one workbook to other when matching data
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 |
All times are GMT +1. The time now is 04:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com