Home |
Search |
Today's Posts |
#1
|
|||
|
|||
URGENT need help with if/then stmt.
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! |
#2
|
|||
|
|||
URGENT need help with if/then stmt.
Locate the information on the individual sheets (cells, column, or rows).
Copy them and paste/special as link on the summary sheet. -- Gary''s Student "Melissa H." wrote: 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! |
#3
|
|||
|
|||
URGENT need help with if/then stmt.
Melissa: A little more information if you please? Can you describe your
workbook? Perhaps you can use something like this? http://www.officearticles.com/excel/...rk sheets.htm ************ Anne Troy www.OfficeArticles.com "Melissa H." <Melissa wrote in message ... 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! |
#4
|
|||
|
|||
URGENT need help with if/then stmt.
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. "Anne Troy" wrote: Melissa: A little more information if you please? Can you describe your workbook? Perhaps you can use something like this? http://www.officearticles.com/excel/...rk sheets.htm ************ Anne Troy www.OfficeArticles.com "Melissa H." <Melissa wrote in message ... 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! |
#5
|
|||
|
|||
URGENT need help with if/then stmt.
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 "Melissa H." wrote in message ... 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. "Anne Troy" wrote: Melissa: A little more information if you please? Can you describe your workbook? Perhaps you can use something like this? http://www.officearticles.com/excel/...rk sheets.htm ************ Anne Troy www.OfficeArticles.com "Melissa H." <Melissa wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Urgent" use script to share the workbook | Excel Discussion (Misc queries) | |||
if/then statement that results in Yes/No | Excel Discussion (Misc queries) | |||
Next w/o For If/Then Loop | Excel Discussion (Misc queries) | |||
Urgent Urgent Urgent!!! | Excel Discussion (Misc queries) | |||
Nested If/Then Math Expert Needed | Excel Worksheet Functions |