How do i create a cumulative worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paula - 07 Mar 2008 13:13 GMT

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 to this Message

Gord Dibben - 07 Mar 2008 22:50 GMT

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

>I have 13 excel worksheets in a workbook. Twelve of them contain various
>account numbers and expiration dates, they have different number of columns
[quoted text clipped - 6 lines]
>
>Thanks to anyone who can help?

Reply to this Message