Linking...

[Oedi]

I have a main workbook that lists all the accounts.

The accounts are each seperate workbooks. I'd like to know if I ente
information in a cell on the account workbook can that informatio
appear in a cell on the list of the main workbook.

Did that make sense?

Thanks,
Jo

 

[Frank Kabel]

Hi
if you data is in one workbook use a formula like
='account_sheet'!A1

 

[Compu Geek]

If you have two separate excel files: Book1 and Book
Book1 has a worksheet called: RawDat
Book2 has a worksheet called: Repor

Then, if you want cell A1 of Report to reference cell A1 of RawData use the formula
=[Book1]RawData!A