Linking fields from one sheet to another

[Deeweb]

Hello,

I have a workbook that contains 20 sheets. My first sheet is a summay sheet that contains specific information from each of the 19 other sheets.

Basically in our office we have equipment that can be checked out. The first sheet provides information about all of the equipment. Sheets 2 - 19 are specific to a single piece of equipment. An associate would enter in their name, date, and when the return date will be. We do not delete the old information, so the next person would add their information to the next line. Instead of looking through each sheet to see if the equipment is available, I would like to create a formula on the summary sheet (sheet 1) that would link the information from sheets 2 -19.

The dilema, since we do not delete old information I can not reference a specific cell in the formula. So if column A is name, column B is date, column C is return date. How do I bring the last available row with information from each of these columns onto the summary sheet via a formula?

Thanks for your help!

 

[gnaga]

=INDIRECT("Sheet1!A"&COUNTA(Sheet1!A:A))

will return the last cell contains value in sheet1 column A. Data presence in column should be continuous.

GNaga

 

[Aladin Akyurek]

...The dilema, since we do not delete old information I can not reference a specific cell in the formula. So if column A is name, column B is date, column C is return date. How do I bring the last available row with information from each of these columns onto the summary sheet via a formula?...

I don't understand why you would want to 'copy' the last entires from all those sheets to the summary sheet.

Activate Insert|Name|Define.
Enter BigNum as name in the Names in Workbook box.
Enter the following in the Refers to box:

9.99999999999999E+307

Click OK.

Suppose you want to retrieve the last entries from Sheet2... In the summary sheet enter...

=MATCH(BigNum,Sheet2!B:B) in someCell.

=INDEX(Sheet2!A:A,Cell)

=INDEX(Sheet2!B:B,Cell)

=INDEX(Sheet2:C:C,Cell)

 

[Deeweb]

This worked beautifully, thank you so much for your help and quick turn around time !!!