| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro copy data from one workbook to other by matching date
Objective to create a monthly report from daily data. I need some help to
create a macro that upon starting looks at a date in workbook1 eg cell e3=19/07/2007, and then opens another workbook2 finds the matching date in a column of range b1-b31, and then copies a range of data from workbook1 alongside the matching date in workbook2. Can anyone help, Cheers 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 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) | |||
| Need Macro to copy some date from one Workbook to another. | Excel Discussion (Misc queries) | |||
| Macro to copy data into another workbook | Excel Discussion (Misc queries) | |||
Hybrid Mode
