Macro to copy data from one sheet to another based on the current date
- by SgtSnafu
Does anyone have a macro that copy data from one sheet to another based on the current date?
I am working with a single workbook of three sheets. Sheet one will hold the manual input of daily production figures for multiple plants, sheet two is to hold ongoing daily data, keyed on sheet one. The macro will be associated with a button, so that once clicked it would search for every row that has a date of today, and copy that row to the next available blank row on sheet two.
Sample Data...
Plant 1 Input
Date - $ Produced - Labor Hour
3-29-10 - 4538 - 8
3-30-10 - 7862 - 12
3-31-10
4-1-10
4-2-10
Plant 2 Input
Date - $ Produced - Labor Hour
3-29-10 - 4545 - 9
3-30-10 - 7645 - 12
3-31-10
4-1-10
4-2-10
