Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro copy data wb1 matching date to wb2
Can someone please help,
I need a macro which copies a range of data from one workbook to another. Wb2 is a monthly summary report which I need to create using the daily data from wb1. I need the macro to open wb2, then look at the single date on wb1, find the matching date in a column of dates in wb2, and then copy a range of data from wb1 alongside the matching date in wb2, if can;t find says date not found and ends???? thanks |
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 to Copy from one workbook to other when matching data | Excel Discussion (Misc queries) | |||
macro copy data from one workbook to other by matching date | Excel Discussion (Misc queries) | |||
Need Macro to copy some date from one Workbook to another. | Excel Discussion (Misc queries) | |||
Matching data using date criteria... | Excel Worksheet Functions |