Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to find matching date and copy values to another sheet
I have 2 spreadsheets, dailydata and datamonth. I need a macro which looks up
the date in dailydata which is in a fixed location, and then finds the matching date in datamonth across a row of monthly dates (e.g. 01 jul to 31 jul) and pastes values from dailydata below the matching date in datamonth. dailydata 3-Jul-07 Start End time 1 7 6 Datamonth Dates 2-Jul-07 3-Jul-07 4-Jul-07 Start Run End Run Run Time Thanks Heaps |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date values change when I copy an excel sheet to a new book | Excel Discussion (Misc queries) | |||
find a cell matching separate column and row values | Excel Worksheet Functions | |||
Copy Macro values to new sheet | New Users to Excel | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Worksheet Functions | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Discussion (Misc queries) |