Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i create a cumulative worksheet
I have 13 excel worksheets in a workbook. Twelve of them contain various
account numbers and expiration dates, they have different number of columns used. I want to create a cumulative sheet that gathers info from 2 columns from each worksheet (vendor name and expire date), and I want the cumulative sheet to update as new info is entered onto the 12 sheets. I selected a cell on the cumulative sheet, went to the 1st vendor sheet to select the vendor name column from cell 2 through 1000, to include future entries (?) and hit enter. I get a 'value' error message. Thanks to anyone who can help? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i create a cumulative worksheet
Paula
Select second cell in vendor name column on cumulate sheet and type the = sign Switch to vendor sheet cell and hit ENTER to get a formula like =Vendor1!B2 On cumulate sheet just copy that link down as far as you want. You will see 0's if no data on vendor sheet. Trap for that in the link formula. =IF(Vendor1!B2="","",Vendor1!B2) Gord Dibben MS Excel MVP On Fri, 7 Mar 2008 05:13:01 -0800, Paula wrote: I have 13 excel worksheets in a workbook. Twelve of them contain various account numbers and expiration dates, they have different number of columns used. I want to create a cumulative sheet that gathers info from 2 columns from each worksheet (vendor name and expire date), and I want the cumulative sheet to update as new info is entered onto the 12 sheets. I selected a cell on the cumulative sheet, went to the 1st vendor sheet to select the vendor name column from cell 2 through 1000, to include future entries (?) and hit enter. I get a 'value' error message. Thanks to anyone who can help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a more than cumulative frequency polygon ? | Excel Discussion (Misc queries) | |||
How do I create a more than cumulative frequency polygon ? | Excel Discussion (Misc queries) | |||
Cumulative Average on a worksheet | New Users to Excel | |||
how do i create a cumulative frequencey graph using excel? | Charts and Charting in Excel | |||
How do you create a cumulative line graph? | Excel Discussion (Misc queries) |