Extracting Data from one workbook to another

[jbobzien]

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

[Pete_UK]

First thing, John, is that a formula cannot "push" data to another
cell, rather it has to be "pulled", which means that you need formula
in your second sheet to drag information from the first.

A simple formula like =Sheet1!A1 can be used to pull information from
cell A1 of Sheet1 into the cell that contains the formula. There are
other functions like MATCH( ) and INDEX( ) and the various lookup
functions which can be used to search for data which matches some
criterion (like date).

However, for us to help you directly, we will need some more details of
exactly what it is you want to do, so can you post these details?

Pete

[jbobzien]

Well let's see if I can give you some more details:

I have workbook1, with 4 sheets in it. Encoding, Bulk, PIM1, PIM2.
Workbook2, I will be pulling information from two colomns in encoding (The workbook I need to pull the information into) has multiple sheets that will continue on infinitely. The titled worksheets at labeled "WE 2-18" "WE 2-25" so forth basically I understand I will have to update the pulling formulas each week, for each new weekly sheet. So basically:
I have two colomns of information I need to pull daily from the Encoding worksheet (C6:C23) and (K6:K23) and put that into the corresponding "WE X-XX" worksheet in another workbook. The WE workbooks track an entire week, and have 5 sets of colomns (each day of the work week) with 2 colomns in each (Data input colomns tracking info from (C6:C23) and (K6:K23)).
* am I spelling colomn right? doesn't seem like it.
So it seems rather difficult to do this. As the Encoding file will remain named Encoding, but will transfer data to different colomns in workbook2 depending on the date. I really have no idea how to get around that problem. If this isn't clear please let me know what areas, and I'll expand on them. Thanks for the help btw.

--John

[Pete_UK]

Does your first workbook (the one with the Encoding sheet in it) just
have its values overwritten each day, or do you keep the previous day's
workbook (i.e. do you have a Monday, Tuesday Wednesday etc workbook?) ?

In your WE sheets, will you have your sets of data in columns A/B, C/D,
E/F, G/H, I/J, or do you have blank columns between? What row in these
sheets do you want the data from the Encoding worksheet to start? (Same
rows, 6 - 23 ?)

Can you arrange to have both workbooks open at the same time?

Pete