Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying Selected Rows From Workbook1 to WorkBook2 [email protected] Excel Discussion (Misc queries) 0 October 10th 06 11:24 PM
Help with copying dynamic column selected based on remote cell value and dynamic formula fill ers Charts and Charting in Excel 0 March 1st 06 01:05 AM
Printing selected rows maacmaac Excel Discussion (Misc queries) 1 December 8th 05 05:15 PM
Why does AutoFilter display rows NOT selected from drop down box? Jo M Excel Discussion (Misc queries) 9 October 15th 05 01:08 AM
Copying formulas to new rows, 20000 times Box Excel Discussion (Misc queries) 3 September 2nd 05 02:20 PM


All times are GMT +1. The time now is 09:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"