linking worksheet pages

  • Thread starter Thread starter Penny
  • Start date Start date
P

Penny

I work in an excel spreadsheet, in it I use many columns
to post total sales for the year. Can I set up a formula
to take certain info on the first page of the workbook
and have it auto post in on the second sheet
automatically. Say I have 100 vendors that I post all
sales on sheet one for the year. Can I take all sales
for Dell and have that auto post on the 2 sheet and all
sales for IBM auto post on the 3rd sheet, etc, etc. This
way I can have the complete year posted on the first
sheet and if the boss ask "how many sales and total of
sales for Dell" I could click in the Dell sheet and have
the total there without doing a lot of sorting.
Hopefully I have made myself clear, the next problem. I
am trying very hard to learn excel but do not understand
it very much YET. I would appreciate any help I can
get. I hope someone can paint a good picture for me.
Many Thanks
 
Just reference the cell or range of cells in another sheet using
"sheetname!A1"
ex. SUM(sheet2!A1:sheet3!A1) or to pull a total from cell B5 in sheet 3:
=sheet3!B5

HTH.
 
Penny,

Have you looked at Data->Filter->Autofilter?

With Autofilter I believe you can get answers to questions like "how many sales
and total of sales for Dell" without having to sort the worksheet or keep
duplicate data in other sheets.

You can also try a Pivot Table which is more powerful.

HTH
Anders Silvén
 
Back
Top