Smurfit-Stone
Active Member
- Joined
- Dec 1, 2004
- Messages
- 485
Hello board,
I need a macro or formula that will search a row of columns on sht 2 to match with a date entered on sht 1, if a match is found, then I need a range of cells copied from sht 1 and pasted on sht 2 in the column with the matching date. example. on sht 1 the date will be enterd on cell E1, (current date). I need to match that date to sht 2 where there are days of the week for the whole month, E3:AH3, if a match then copy data from sht 1 D27:D48 and paste with corresponding date on sht2 in rows 9 thru 30 of the matching date.
Sheet 1 had a date in E1 daily and data entered in cells D27:48, Sheet 2 has columns with date headings (E3:AH3). If date on sht 1 E1 matches date on sht 2 range (e3:ah3) then copy data from sht1 range D27:D48 and paste under correct matched date on sht2. I hope that made sense. Please help...Thanks in advance.
I need a macro or formula that will search a row of columns on sht 2 to match with a date entered on sht 1, if a match is found, then I need a range of cells copied from sht 1 and pasted on sht 2 in the column with the matching date. example. on sht 1 the date will be enterd on cell E1, (current date). I need to match that date to sht 2 where there are days of the week for the whole month, E3:AH3, if a match then copy data from sht 1 D27:D48 and paste with corresponding date on sht2 in rows 9 thru 30 of the matching date.
Sheet 1 had a date in E1 daily and data entered in cells D27:48, Sheet 2 has columns with date headings (E3:AH3). If date on sht 1 E1 matches date on sht 2 range (e3:ah3) then copy data from sht1 range D27:D48 and paste under correct matched date on sht2. I hope that made sense. Please help...Thanks in advance.
