write records to another worksheet based on criteria

  • Thread starter Thread starter goss
  • Start date Start date
G

goss

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
 
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.
 
Back
Top