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/