Macro to copy data from one sheet to another based on the current date

Posted by SgtSnafu on Stack Overflow See other posts from Stack Overflow or by SgtSnafu
Published on 2010-03-29T15:18:41Z Indexed on 2010/06/15 9:02 UTC
Read the original article Hit count: 279

Filed under:
|
|

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

© Stack Overflow or respective owner

Related posts about excel

Related posts about vbscript