a summary sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kinsey - 04 Jul 2009 07:52 GMT

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?

Signature

kinsey

Reply to this Message

Simon Lloyd - 04 Jul 2009 08:31 GMT

kinsey;403772 Wrote:

> Hello, I have a number of sheets in a workbook that have one stock item
> on
[quoted text clipped - 7 lines]
> --
> 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.

Signature

Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)

Reply to this Message

Shane Devenshire - 05 Jul 2009 19:31 GMT

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.

Signature

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

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

Reply to this Message

kinsey - 19 Jul 2009 07:43 GMT

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

Signature

kinsey

> Hi,
>
[quoted text clipped - 12 lines]
> >
> > Is this possible?

Reply to this Message