a summary sheet

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?
 
S

Shane Devenshire

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

data to summary sheet for a dummy 0
Summary sheet 3
referencing another sheet and using auto fill 10
Linking to Summary Sheet Changing Range 2
Help Automatically Populating A Summary sheet 1
Summary sheet 2
Text summary 1
Copying same data range to a summary sheet 8

Top