Smurfit-Stone
Active Member
- Joined
- Dec 1, 2004
- Messages
- 485
Hello Board,
I have a book with two sheets. One is for a week's worth of data and the other is for daily data. I need a macro or formula that does a lookup ( to match a date on sheet1, then find that date on sheet2) then perform a copy from sheet1, then paste to the appropriate (matched) column on sheet 2.
Sheet 2 has columns (E4:K4) labeled with the days of the week i.e. 7/11/2011, 7/12/2011. etc. Sheet 1 would have todays date entered in cell E1. If the date on sheet 1, E1, matched a date between E4:K4, the macro or formula would copy the data from sheet 1, D27:D48 and plaste it on sheet2 in the column for the appropriate matched date. Hope I made sense. Thanks in advance
I have a book with two sheets. One is for a week's worth of data and the other is for daily data. I need a macro or formula that does a lookup ( to match a date on sheet1, then find that date on sheet2) then perform a copy from sheet1, then paste to the appropriate (matched) column on sheet 2.
Sheet 2 has columns (E4:K4) labeled with the days of the week i.e. 7/11/2011, 7/12/2011. etc. Sheet 1 would have todays date entered in cell E1. If the date on sheet 1, E1, matched a date between E4:K4, the macro or formula would copy the data from sheet 1, D27:D48 and plaste it on sheet2 in the column for the appropriate matched date. Hope I made sense. Thanks in advance
