Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to copy data with a date criteria
Help is needed:
I have the following spreadsheet: A b c d e Crse1 01/08/07 08/08/07 16/08/07 23/08/07 Crse2 08/08/07 16/08/07 23/08/07 30/08/07 crse3 16/08/07 23/08/07 30/08/07 8/09/07 This is just a small part of the spreadsheet, it's about 300 rows and 40 columns. I need the macro to copy all the data in each row into another spreadsheet if the date in any of the colums matches a specific date, todays date as this will be run on each day. Eg todays date 08/08/07, so this would return the data in column A for rows 1 & 2 but not column 3. Any help will be greatly appreciated. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro copy with criteria | Excel Discussion (Misc queries) | |||
macro copy data wb1 matching date to wb2 | Excel Discussion (Misc queries) | |||
macro copy data from one workbook to other by matching date | Excel Discussion (Misc queries) | |||
Attempting to copy/paste data from one worksheet to another (same info but diff layout) based on date criteria | Excel Programming | |||
Macro or formula to copy data based on criteria | Excel Programming |