Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
write records to another worksheet based on criteria
Hi all.
Using xl xp pro Trying to come up with a way to store user input from schedule_build! to schedule_dat! The data to be written based on user selection of profit center and period So if user selects pc 001 and period 5 record would be written from schedule_build!E69:H69 to schedule_Dat!V5:Y5 Schedule templates are broken by periods 1-12 Some periods (Sept, Dec, Mar) are 5 week all others are 4 week All templates stored on schedule_build! Schedule_Dat! tables are divided: Hours Labor Hrs Labor $ Each table 52 weeks/yr x 43 profit centers Thanks for all of the great help --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
write records to another worksheet based on criteria
Use the Autofilter to make all but the records you are interested hidden.
Then copy the autofilter data (only visible records will be copied). Turn on the macro recorder while you do it manually - then modify the code to generalize it: Data=Filter=Autofilter in the dropdowns in your column, select your criteria. Select a cell in the autofilter and do Ctrl+Shift+8 to select the data region. Then edit =copy and go to the new sheet, then edit paste. -- Regards, Tom Ogilvy "goss " wrote in message ... Hi all. Using xl xp pro Trying to come up with a way to store user input from schedule_build! to schedule_dat! The data to be written based on user selection of profit center and period So if user selects pc 001 and period 5 record would be written from schedule_build!E69:H69 to schedule_Dat!V5:Y5 Schedule templates are broken by periods 1-12 Some periods (Sept, Dec, Mar) are 5 week all others are 4 week All templates stored on schedule_build! Schedule_Dat! tables are divided: Hours Labor Hrs Labor $ Each table 52 weeks/yr x 43 profit centers Thanks for all of the great help --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy multiple records based on criteria or total amount | Excel Discussion (Misc queries) | |||
Count Unique records based on the Criteria in another colum | Excel Worksheet Functions | |||
Count Unique records based on the Criteria in another colum | Excel Worksheet Functions | |||
Count Unique records based on the Criteria in another colum | Excel Worksheet Functions | |||
Show top five records based on meeting multiple criteria | Excel Worksheet Functions |