Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting
I would like to ask how to write a formula to summarize info on a separate
worksheet within the current workbook. Example: Info is on Sheet 1 in C1 & C2, and Sheet 1 in E1 & E2, and I want to display on Sheet 2 A1 & A2, and Sheet 2 A4 & A5, with a blank row between A2 & A4 the numbers that are on Sheet 1 Sheet1! On my list of numbers, I first copied and pasted 200 #'s in B1, and in C1 wrote the formula =SUM(B1), then in C2 I wrote =SUM(B200), and repeated this 150 times. Then on Sheet2 so I could print all 150 pairs of answers on one sheet to easily reference. I wrote the following example starting in B1, repeated this 12 times to get all 150 pairs of answers. I wrote Down 13 sets of 3 rows, then over to the right starting in D1, D2, etc. Column A1 Column B1 1 =SUM(Sheet1!B1) and =SUM(Sheet1!B2) A4 is a Blank Row 2 =SUM(Sheet1!D1) and =SUM(Sheet1!D2) Etc. I was looking for an easier way to get the info from Sheet1! and Sheet2! onto my summary sheet; Sheet3! This took me about 2 hours. I hope there is an easier way to do this. Sorry for being so wordy. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting
No need for sum if you only want to link a cell from another sheet, you can
just copy the cell(s), then do editpaste special and select link -- Regards, Peo Sjoblom "talltom" wrote in message ... I would like to ask how to write a formula to summarize info on a separate worksheet within the current workbook. Example: Info is on Sheet 1 in C1 & C2, and Sheet 1 in E1 & E2, and I want to display on Sheet 2 A1 & A2, and Sheet 2 A4 & A5, with a blank row between A2 & A4 the numbers that are on Sheet 1 Sheet1! On my list of numbers, I first copied and pasted 200 #'s in B1, and in C1 wrote the formula =SUM(B1), then in C2 I wrote =SUM(B200), and repeated this 150 times. Then on Sheet2 so I could print all 150 pairs of answers on one sheet to easily reference. I wrote the following example starting in B1, repeated this 12 times to get all 150 pairs of answers. I wrote Down 13 sets of 3 rows, then over to the right starting in D1, D2, etc. Column A1 Column B1 1 =SUM(Sheet1!B1) and =SUM(Sheet1!B2) A4 is a Blank Row 2 =SUM(Sheet1!D1) and =SUM(Sheet1!D2) Etc. I was looking for an easier way to get the info from Sheet1! and Sheet2! onto my summary sheet; Sheet3! This took me about 2 hours. I hope there is an easier way to do this. Sorry for being so wordy. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
more sorting | Excel Worksheet Functions | |||
Sorting | Excel Worksheet Functions | |||
Sorting: Sorting by the First Character | Excel Discussion (Misc queries) | |||
Help With Sorting | Excel Discussion (Misc queries) | |||
sorting | Excel Discussion (Misc queries) |