I'm not real sure what you're looking to do here. Is
your issue with how to get the totals from column 3 in
workbook 1 into column 2 of workbook 2? Or, are you
looking to get each line in column 3, workbook 1 into
column 2, workbook 2?
Try these steps from the Excel XP help guide:
Click the cell that contains the data you want to link
to, and then click Copy on the Standard toolbar.
Click the cell you want to link from, and then click
Paste .
Click Paste Options and then click Link Cells.
Create a link between cells in different workbooks
Open both the workbook that will contain the link (called
the destination workbook), and the workbook that contains
the data you want to link to (called the source
workbook).
In the destination workbook, click Save .
Select a cell or cells you want to link from.
If you are creating a new formula, type = (an equal
sign).
If you are entering the link elsewhere in the formula,
type the operator or function that you want to precede
the link.
On the Window menu, click the name of the source
workbook, and then click the worksheet that contains the
cells you want to link to.
Select the cells you want to link to.
Complete the formula. When you finish entering the
formula, press ENTER.
-----Original Message-----
I have made a weekly workbook as so - column 1 is
inventory, rows under that have a list of all inventory
items, next columns are for the days of the week, rows
under these are used to put how many of that item was
sold for that day, the last column is for total for the
week and the rows under that total how many of that item
was sold for that week. I made another workbook as so -
column 1 is inventory, rows under this is a list of
inventory items, column 2 is total sold for the week,
this is where I need the data from my other workbook's
last column, column 3 is my price list per item, rows
under this contain the price for each item, column 4 is
the total for the week, rows under this show the total
for each item sold for the week, 1 row under this is the
complete money taken in for the week. Could someone help
me here or point me to a good page that will teach me
about this, not sure what to call it thats why I'm having
trouble finding it.
