a summary sheet
 

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

a summary sheet
 

kinsey;403772 Wrote:
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?
--
kinseyNot knowing the structure or range on each of your sheets i suggest
using VLookup on your summary sheet, so lets say in B1 of your summary
sheet you can enter =VLOOKUP(A1,Sheet2!A1:M20,2,FALSE) this will look at
the name in A1 of your summary sheet and return the value of the match
found in sheet2 from column C (2) from the range A1:M20, the FALSE means
only return a value if its an exact match.

You can work out how to extend this for more data along a row.

Hope this helps.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=112595

a summary sheet
 

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"kinsey" wrote:

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

a summary sheet
 

Shane, thanks again for your help. This works a treat!
--
kinsey


"Shane Devenshire" wrote:

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"kinsey" wrote:

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