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