URGENT need help with if/then stmt.

M

Melissa H.

I am in need of a way to pull information from multiple worksheets on to a
"summary page" within the same workbook. I am a marketing assistant, and
need a way to condense our order information onto a one page summary. Please
help, deadline fast approaching!
 
G

Gary''s Student

Locate the information on the individual sheets (cells, column, or rows).
Copy them and paste/special as link on the summary sheet.
 
M

Melissa H.

Anne,
Thank you for your response, you asked that i give you a little more
information. I have worksheets for the following commodities corn, beans,
and forage, on each of these worksheets have a colom headings such as
variety, quanity treatment. Here is what I would like to do, I would like to
have all of the different varieties automatically fill in on the summary page
with a running total of all sales of that variety.
 
A

Anne Troy

Okay. Consider this, Melissa:
Put all your totals on row 1 of each of those worksheets. =sum(c3:c65536)
would be a typical formula for getting your totals, regardless of how many
rows are used.
Then, create a summary sheet by copying each row 1 and paste-special, paste
link. Would that do it for ya?
Maybe I need to see your workbook if that doesn't sound like it would help.
Send it to anne@ the website below my name.
************
Anne Troy
www.OfficeArticles.com
 
Top