Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Selected Rows From Workbook1 to WorkBook2
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Selected Rows From Workbook1 to WorkBook2 | Excel Discussion (Misc queries) | |||
Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
Printing selected rows | Excel Discussion (Misc queries) | |||
Why does AutoFilter display rows NOT selected from drop down box? | Excel Discussion (Misc queries) | |||
Copying formulas to new rows, 20000 times | Excel Discussion (Misc queries) |