I have setup a new worksheet that tracks daily hours and piece counts. I
want to have it update to another pre-existing workbook daily, so I can
track progression of production for weeks, months, and years. The
workbook that already exists for tracking data production is setup to
do what i need it to do. However, I don't really know how I can get the
information from my work sheet, to automatically update itself into the
2nd workbook. I'm assuming I can somehow use the date on worksheet to
link it to the correct date in the 2nd workbook. lemme see if I can
reword all this so it's a little clearer.

I have worksheet (encoding) in workbook 1. This worksheet is updated,
printed, and cleared each day. The second workbook (PPH Tracking)
keeps a weekly update tracking pieces per hour. The worksheet that does
this in (PPH Tracking) is then copied into a new worksheet that all have
date ranges as names (weekly). Now as of right now these two workbooks
are seperate, but I'd like to link them together so it works
automatically, stream lining this process to save me, and other people
in management production time. I was wondering how I might go about
this, or what I would look under in the help file at least. Any
comments or suggestions would be appreciated.

--John


--
jbobzien
------------------------------------------------------------------------
jbobzien's Profile: http://www.excelforum.com/member.php...o&userid=31696
View this thread: http://www.excelforum.com/showthread...hreadid=514364