a summary sheet

  • Thread starter Thread starter kinsey
  • Start date Start date
K

kinsey

Hello, I have a number of sheets in a workbook that have one stock item on
each which I update and then give me a reducing balance. Simply what I want
to do is have a separate sheet which has a summary of the each of the stock
items and automatically updates as I amend each sheet.

Is this possible?
 
Hi,

Well we don't know anything about the structure of your spreadsheets, but
lets suppose the number you want to bring back to the Summary sheet is the
last number in column C on each sheet then use something like this

=LOOKUP(9^9,Sheet1!C:C)

you will need a separate formula for each sheet.
 
Back
Top