Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I copy text from one worksheet to another
I am having a hard time and hope someone can help me!
I have a large spreadsheet that holds data, both numeric and alpha, and has 12 worksheets within the spreadsheet for each months' data. What I need to do is create another worksheet titled Summary, which would give me a summary of the information I need (not all on each worksheet is pertinant) at the end of each year. It would be easiest if I could create a formula to pull the information I need and add it to my summary worksheet rather than cut and paste each worksheets' information to my summary worksheet. I hope I explained this correctly. Thanks everyone! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I copy text from one worksheet to another
On sheet10 use formulas like =Sheet1!Z20 to get Z20 value from Sheet1
Use formula like =SUM(Sheet1:Sheet9!Z10) to sum all Z10 values Any help? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Kendra" wrote in message ... I am having a hard time and hope someone can help me! I have a large spreadsheet that holds data, both numeric and alpha, and has 12 worksheets within the spreadsheet for each months' data. What I need to do is create another worksheet titled Summary, which would give me a summary of the information I need (not all on each worksheet is pertinant) at the end of each year. It would be easiest if I could create a formula to pull the information I need and add it to my summary worksheet rather than cut and paste each worksheets' information to my summary worksheet. I hope I explained this correctly. Thanks everyone! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I copy text from one worksheet to another
Actually, treat me like I am 10 and you are trying to explain this to me. I
am very good at certain functions in excel, so I am not new to it, but anything with the formulas, I normally only do the SUM of numeric figures, so this one is tricky. Sorry to be such a pain! :) For example - your example of Sheet1!Z20 - what is the Z20 representing? "Bernard Liengme" wrote: On sheet10 use formulas like =Sheet1!Z20 to get Z20 value from Sheet1 Use formula like =SUM(Sheet1:Sheet9!Z10) to sum all Z10 values Any help? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Kendra" wrote in message ... I am having a hard time and hope someone can help me! I have a large spreadsheet that holds data, both numeric and alpha, and has 12 worksheets within the spreadsheet for each months' data. What I need to do is create another worksheet titled Summary, which would give me a summary of the information I need (not all on each worksheet is pertinant) at the end of each year. It would be easiest if I could create a formula to pull the information I need and add it to my summary worksheet rather than cut and paste each worksheets' information to my summary worksheet. I hope I explained this correctly. Thanks everyone! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I copy text from one worksheet to another
Hi Kendra:
You have 12 sheets with data for each month; you want to have some of the data summarized on another sheet. Suppose the data you want comes from Z20 on Sheet1, then on the summary sheet use =Sheet1!Z20 and the cell on the summary sheet will display the same value as cell Z20 on Sheet1 If you want to sum the Z10 values on Sheet1, Sheet2....all the way to Sheet12 use =SUM(Sheet1:Sheet12!Z10) -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Kendra" wrote in message ... Actually, treat me like I am 10 and you are trying to explain this to me. I am very good at certain functions in excel, so I am not new to it, but anything with the formulas, I normally only do the SUM of numeric figures, so this one is tricky. Sorry to be such a pain! :) For example - your example of Sheet1!Z20 - what is the Z20 representing? "Bernard Liengme" wrote: On sheet10 use formulas like =Sheet1!Z20 to get Z20 value from Sheet1 Use formula like =SUM(Sheet1:Sheet9!Z10) to sum all Z10 values Any help? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Kendra" wrote in message ... I am having a hard time and hope someone can help me! I have a large spreadsheet that holds data, both numeric and alpha, and has 12 worksheets within the spreadsheet for each months' data. What I need to do is create another worksheet titled Summary, which would give me a summary of the information I need (not all on each worksheet is pertinant) at the end of each year. It would be easiest if I could create a formula to pull the information I need and add it to my summary worksheet rather than cut and paste each worksheets' information to my summary worksheet. I hope I explained this correctly. Thanks everyone! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I copy text from one worksheet to another
Awesome!!! I am going to give that a shot and I will let you know how it
works! Thanks so much! Kendra "Bernard Liengme" wrote: Hi Kendra: You have 12 sheets with data for each month; you want to have some of the data summarized on another sheet. Suppose the data you want comes from Z20 on Sheet1, then on the summary sheet use =Sheet1!Z20 and the cell on the summary sheet will display the same value as cell Z20 on Sheet1 If you want to sum the Z10 values on Sheet1, Sheet2....all the way to Sheet12 use =SUM(Sheet1:Sheet12!Z10) -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Kendra" wrote in message ... Actually, treat me like I am 10 and you are trying to explain this to me. I am very good at certain functions in excel, so I am not new to it, but anything with the formulas, I normally only do the SUM of numeric figures, so this one is tricky. Sorry to be such a pain! :) For example - your example of Sheet1!Z20 - what is the Z20 representing? "Bernard Liengme" wrote: On sheet10 use formulas like =Sheet1!Z20 to get Z20 value from Sheet1 Use formula like =SUM(Sheet1:Sheet9!Z10) to sum all Z10 values Any help? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Kendra" wrote in message ... I am having a hard time and hope someone can help me! I have a large spreadsheet that holds data, both numeric and alpha, and has 12 worksheets within the spreadsheet for each months' data. What I need to do is create another worksheet titled Summary, which would give me a summary of the information I need (not all on each worksheet is pertinant) at the end of each year. It would be easiest if I could create a formula to pull the information I need and add it to my summary worksheet rather than cut and paste each worksheets' information to my summary worksheet. I hope I explained this correctly. Thanks everyone! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I copy text from one worksheet to another
This was great! Thanks so much. I have another question and wanted to post it
as a new one, but now when I hit new question, nothing happens. Anyway, I am trying to sort colums that have titles and the titles keep getting sorted alphabetically even though I don't select them before I hit the AZ key to sort ascending. Am I doing something wrong? It really is going to defeat my whole purpose if I can't get them to sort once the information has been extraced. Thanks Bernard! Kendra "Bernard Liengme" wrote: Hi Kendra: You have 12 sheets with data for each month; you want to have some of the data summarized on another sheet. Suppose the data you want comes from Z20 on Sheet1, then on the summary sheet use =Sheet1!Z20 and the cell on the summary sheet will display the same value as cell Z20 on Sheet1 If you want to sum the Z10 values on Sheet1, Sheet2....all the way to Sheet12 use =SUM(Sheet1:Sheet12!Z10) -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Kendra" wrote in message ... Actually, treat me like I am 10 and you are trying to explain this to me. I am very good at certain functions in excel, so I am not new to it, but anything with the formulas, I normally only do the SUM of numeric figures, so this one is tricky. Sorry to be such a pain! :) For example - your example of Sheet1!Z20 - what is the Z20 representing? "Bernard Liengme" wrote: On sheet10 use formulas like =Sheet1!Z20 to get Z20 value from Sheet1 Use formula like =SUM(Sheet1:Sheet9!Z10) to sum all Z10 values Any help? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Kendra" wrote in message ... I am having a hard time and hope someone can help me! I have a large spreadsheet that holds data, both numeric and alpha, and has 12 worksheets within the spreadsheet for each months' data. What I need to do is create another worksheet titled Summary, which would give me a summary of the information I need (not all on each worksheet is pertinant) at the end of each year. It would be easiest if I could create a formula to pull the information I need and add it to my summary worksheet rather than cut and paste each worksheets' information to my summary worksheet. I hope I explained this correctly. Thanks everyone! |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I copy text from one worksheet to another
I always advise people NOT to use the sort AZ icons!
It is better to highlight the data you want to sort, including any header row, then select Data | Sort and specify your parameters - the column you want to sort on (you can choose up to 3), whether you want it sorted in ascending or descending order, and if your data contains a header row (Excel will try to guess this for you). You thus have more flexibility but also more control over what gets sorted. Hope this helps. Pete |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I copy text from one worksheet to another
Thanks Pete, I will try doing it this way and see if it works! :)
"Pete" wrote: I always advise people NOT to use the sort AZ icons! It is better to highlight the data you want to sort, including any header row, then select Data | Sort and specify your parameters - the column you want to sort on (you can choose up to 3), whether you want it sorted in ascending or descending order, and if your data contains a header row (Excel will try to guess this for you). You thus have more flexibility but also more control over what gets sorted. Hope this helps. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how Excel can copy the data in a row of worksheet to other? | Excel Worksheet Functions | |||
Formula to copy text from a column in different workshhets | Excel Worksheet Functions | |||
Copy worksheet & maintain cell reference across worksheets | Excel Worksheet Functions | |||
Is there a function to copy an entire worksheet? | Excel Worksheet Functions | |||
Copy answer to another worksheet | Excel Discussion (Misc queries) |