Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
$%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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to find matching date and copy values to another sheet | Excel Discussion (Misc queries) | |||
macro copy data from one workbook to other by matching date | Excel Discussion (Misc queries) | |||
macro for copy data from all worksheets of a workbook to single sh | Excel Discussion (Misc queries) | |||
Macro Help. Copy data from 1 workbook to another on next available | Excel Discussion (Misc queries) | |||
Macro to copy data into another workbook | Excel Discussion (Misc queries) |