S
seanswilson
I have a workbook with several sheets that I need to copy selected rows
of data from based on a date range into another workbook with monthly
sheets, and need help.
Workbook1 is the main workbook with the main data on the 'Master'
worksheet. The date field that I need to check on is in Column L.
Workbook2 is the secondary workbook where the selected data has to be
copied into. There are currently 12 worksheets, one for each month.
What I was hoping to do was have another worksheet with a series of
buttons labelled January to December on it, with an associated
macro/VBA to copy the relevant data.
Therefore, for the likes of the January button, I would need a
macro/VBA code that would search column L of the Master sheet of
Workbook1 for any records that fall within the date range 1st Jan to
31st Jan. It would then need to select those rows, copy them and then
paste them into the January worksheet of Workbook2, starting at row 2
(row 1 having the column headings).
Any help would be appreciated.
of data from based on a date range into another workbook with monthly
sheets, and need help.
Workbook1 is the main workbook with the main data on the 'Master'
worksheet. The date field that I need to check on is in Column L.
Workbook2 is the secondary workbook where the selected data has to be
copied into. There are currently 12 worksheets, one for each month.
What I was hoping to do was have another worksheet with a series of
buttons labelled January to December on it, with an associated
macro/VBA to copy the relevant data.
Therefore, for the likes of the January button, I would need a
macro/VBA code that would search column L of the Master sheet of
Workbook1 for any records that fall within the date range 1st Jan to
31st Jan. It would then need to select those rows, copy them and then
paste them into the January worksheet of Workbook2, starting at row 2
(row 1 having the column headings).
Any help would be appreciated.