Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
carrying over a column formula from one sheet to another copied sh
I have a worksheet that has three columns all part of a formula. Very
simple, the first column is the beginning subtotal, the second is any additional numbers, the last column is the total of the two previous columns. I want to make copies of the master sheet and carry over the total from one sheet to the next copied sheet, however I need the numbers in the Total column to end up in the Subtotal column of the copied sheet, and so on with multiple copies. Can this be done? Thank you for your valued suggestions! Carl |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
carrying over a column formula from one sheet to another copied sh
Assume you only have one sheet - Sheet1 - and that you are using
columns A, B and C starting in row 2, allowing a row for headings. You can copy the sheet into the same workbook by CTRL-drag, i.e. hold the CTRL key down and drag the tab of Sheet1. Rename this second sheet as Sheet2, and in A2 enter this formula: =Sheet1!C2 Copy this formula down for as many items as you have in Sheet1. You might like to clear all the data from column B of this sheet. Now, copy Sheet2 using CTRL-drag and rename it to Sheet3. Highlight column A of Sheet3 and press CTRL-H (same as Edit | Replace) and enter these: Find What: Sheet1 Replace With: Sheet2 Click Replace All. You can repeat this procedure until you have enough sheets. Hope this helps. Pete Carl wrote: I have a worksheet that has three columns all part of a formula. Very simple, the first column is the beginning subtotal, the second is any additional numbers, the last column is the total of the two previous columns. I want to make copies of the master sheet and carry over the total from one sheet to the next copied sheet, however I need the numbers in the Total column to end up in the Subtotal column of the copied sheet, and so on with multiple copies. Can this be done? Thank you for your valued suggestions! Carl |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
carrying over a column formula from one sheet to another copie
Thanks again Pete, BTW, I checked out the cpearson.com link and found it
very helpful too. Thanks for that tip! Carl "Pete_UK" wrote: Assume you only have one sheet - Sheet1 - and that you are using columns A, B and C starting in row 2, allowing a row for headings. You can copy the sheet into the same workbook by CTRL-drag, i.e. hold the CTRL key down and drag the tab of Sheet1. Rename this second sheet as Sheet2, and in A2 enter this formula: =Sheet1!C2 Copy this formula down for as many items as you have in Sheet1. You might like to clear all the data from column B of this sheet. Now, copy Sheet2 using CTRL-drag and rename it to Sheet3. Highlight column A of Sheet3 and press CTRL-H (same as Edit | Replace) and enter these: Find What: Sheet1 Replace With: Sheet2 Click Replace All. You can repeat this procedure until you have enough sheets. Hope this helps. Pete Carl wrote: I have a worksheet that has three columns all part of a formula. Very simple, the first column is the beginning subtotal, the second is any additional numbers, the last column is the total of the two previous columns. I want to make copies of the master sheet and carry over the total from one sheet to the next copied sheet, however I need the numbers in the Total column to end up in the Subtotal column of the copied sheet, and so on with multiple copies. Can this be done? Thank you for your valued suggestions! Carl |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
carrying over a column formula from one sheet to another copie
You're welcome, Carl, thanks for feeding back.
Pete Carl wrote: Thanks again Pete, BTW, I checked out the cpearson.com link and found it very helpful too. Thanks for that tip! Carl "Pete_UK" wrote: Assume you only have one sheet - Sheet1 - and that you are using columns A, B and C starting in row 2, allowing a row for headings. You can copy the sheet into the same workbook by CTRL-drag, i.e. hold the CTRL key down and drag the tab of Sheet1. Rename this second sheet as Sheet2, and in A2 enter this formula: =Sheet1!C2 Copy this formula down for as many items as you have in Sheet1. You might like to clear all the data from column B of this sheet. Now, copy Sheet2 using CTRL-drag and rename it to Sheet3. Highlight column A of Sheet3 and press CTRL-H (same as Edit | Replace) and enter these: Find What: Sheet1 Replace With: Sheet2 Click Replace All. You can repeat this procedure until you have enough sheets. Hope this helps. Pete Carl wrote: I have a worksheet that has three columns all part of a formula. Very simple, the first column is the beginning subtotal, the second is any additional numbers, the last column is the total of the two previous columns. I want to make copies of the master sheet and carry over the total from one sheet to the next copied sheet, however I need the numbers in the Total column to end up in the Subtotal column of the copied sheet, and so on with multiple copies. Can this be done? Thank you for your valued suggestions! Carl |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date formula that adds 7 days to a cell when sheet is copied | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions |