Problems With Data between datasheets/workbooks

[OntITGuy]

I would like to know if it is possible to have data from one page of
workbook automatically sent to another page.

IE: I have data of case numbers that I fill in daily, and I also hav
another book that has the monthly report. Currently I have to cut an
paste the information between workbooks, and that gets a littl
tedious. I would like to know if there is any way to define a cell t
have it copy (export) it's data to another cell, Keeping in mind tha
the cell references will not be the same. IE: a25 in the daily workboo
may be a146 in the monthly workbook?

any help or suggestions would be greatly appreciated

 

[Don Guillett]

Yes, it is possible with formulas or macros. More info needed for comments.

 

[OntITGuy]

What I am looking to do is:

I have a Column of Data in Column B with case Numbers (regular numbers
no formatting needed) on Sheets 1-5 (a daily log of case
(Monday-Friday) and I would like to be able to automatically copy thi
information to Column B of a second Workbook. The Information comin
from Workbook 1 would be appended to the end of the list in Workboo
2.

For example: it would go from 5 sheets of 10 cases to one sheet of 50
but the sheet of 50 would be in another workbook, and the cases fro
the next week would be appended to the end of the list of 50. So fo
example if I had 10 cases per sheet in book 1, and 4 Books of weekl
Sheets the Book of the Monthly data would have 200 rows

Hopefully this helps clear it u

 

[Gord Dibben]

Using your example......

Some clarification needed here.

"data from one page of a workbook to another page" could mean two worksheets
in one workbook or two workbooks with a sheet in each.

For the latter........

At A146 of Monthly sheet enter =[Daily.xls]Sheet1!$A$25

This will "link" the cells in the separate workbooks.

Note: you will asked "do you want to update links" whenever you open the
Monthly workbook.

If you are meaning different worksheets in one workbook leave out the
[Daily.xls] part.

File is a Workbook. Workbooks contain Worksheets. Worksheets can have
"pages" when printing.

Gord Dibben XL2002

 

[OntITGuy]

What I Needed was Copying between Workbooks, and you answered that Quit
well. Now all I need is fix up the macros to append the data and I wil
be done

Thank you very much for your assistance :