Capturing Totals from workbooks put into summary sheet

October 21, 2013 at 09:21:49
Specs: Windows 7
Need to know the best way to capture totals number of accounts and total dollar amount from several workbooks and put them into a summary sheet. Total number of accounts are always different as well as the total dollar amount.

See More: Capturing Totals from workbooks put into summary sheet

Report •


#1
October 22, 2013 at 16:48:29
Why can't you use a formula that references the ranges in each workbook?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
October 23, 2013 at 06:07:52
I do use formulas to reference ranges in each workbook. I thought there was another way to do it faster and easier. Thanks for your help.

Report •

#3
October 23, 2013 at 09:23:11
Without more details about what you are doing/trying to do, it's hard to offer any suggestions.

Since formulas update automatically, I'm not quite sure why you think there would be a "faster" method. If you'll supply some more details, perhaps we can help you out.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions


Ask Question