Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel - Formulae across several sheets
I have a period (4 week) sales goal. As I complete week 1, I need to know
how much remains of my sales goal. I created a spreadsheet which tracks sales for many accounts for one week (or sheet) at a time. On sheet 2 I need to subtract the total sales from sheet 1 and show remaining sales goal as of week (sheet) 2. Basically, on week (sheet) 4 I need to know what remains for that week. How do I transfer data from sheet 1 to sheet 2; then cumulatively to sheet 3, and finally, cumulatively to sheet 4. Any help will be sincerely appreciated! HELP!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel - Formulae across several sheets
Hi
Say on sheet1 you start with this layout. Column A & Column B Month Sales Target 5000 Cumulative Sales 1892 Remaining Target 3108 Date Amount 01/02/2008 456 02/02/2008 200 ..... Formula in B2 is =SUM(B5:B200) alter range to suit. Formulas in B3 is =B1-b2 Copy the top fours rows to sheets 2,3 and 4. Select the the rows to copy, then Click sheet2 tab press Ctrl then click the sheet4 tab and press enter and the it will be copied to each sheet. the formulas in sheets2 to sheet4 in B2 need to be altered to Sheet2B2: =Sheet1!B2+SUM(Sheet2!B5:B200) sheet3 B2: =Sheet2!$B$2+SUM(Sheet3!$B$5:$B$200) sheet 4 B2: =Sheet3!$B$2+SUM(Sheet4!$B$5:$B$200) This should get you started. Peter "Realoldchipguy" wrote: I have a period (4 week) sales goal. As I complete week 1, I need to know how much remains of my sales goal. I created a spreadsheet which tracks sales for many accounts for one week (or sheet) at a time. On sheet 2 I need to subtract the total sales from sheet 1 and show remaining sales goal as of week (sheet) 2. Basically, on week (sheet) 4 I need to know what remains for that week. How do I transfer data from sheet 1 to sheet 2; then cumulatively to sheet 3, and finally, cumulatively to sheet 4. Any help will be sincerely appreciated! HELP!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel - Formulae across several sheets
Thanks my friend, I will definately give this a try. I appreciate your rapid
response. "Billy Liddel" wrote: Hi Say on sheet1 you start with this layout. Column A & Column B Month Sales Target 5000 Cumulative Sales 1892 Remaining Target 3108 Date Amount 01/02/2008 456 02/02/2008 200 .... Formula in B2 is =SUM(B5:B200) alter range to suit. Formulas in B3 is =B1-b2 Copy the top fours rows to sheets 2,3 and 4. Select the the rows to copy, then Click sheet2 tab press Ctrl then click the sheet4 tab and press enter and the it will be copied to each sheet. the formulas in sheets2 to sheet4 in B2 need to be altered to Sheet2B2: =Sheet1!B2+SUM(Sheet2!B5:B200) sheet3 B2: =Sheet2!$B$2+SUM(Sheet3!$B$5:$B$200) sheet 4 B2: =Sheet3!$B$2+SUM(Sheet4!$B$5:$B$200) This should get you started. Peter "Realoldchipguy" wrote: I have a period (4 week) sales goal. As I complete week 1, I need to know how much remains of my sales goal. I created a spreadsheet which tracks sales for many accounts for one week (or sheet) at a time. On sheet 2 I need to subtract the total sales from sheet 1 and show remaining sales goal as of week (sheet) 2. Basically, on week (sheet) 4 I need to know what remains for that week. How do I transfer data from sheet 1 to sheet 2; then cumulatively to sheet 3, and finally, cumulatively to sheet 4. Any help will be sincerely appreciated! HELP!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delete sheets from a workbook without creating linked formulae | Excel Discussion (Misc queries) | |||
formulae to look at 52 sheets &count if 2 cells have data entered | Excel Discussion (Misc queries) | |||
formulae to look at 52 sheets &count if 2 cells have data entered | Excel Discussion (Misc queries) | |||
formulae to look at 52 sheets &count if 2 cells have data entered | Excel Discussion (Misc queries) | |||
repost; Automatically updating formulae in multiple sheets | Excel Discussion (Misc queries) |