I have three country tabs. Each one has accounts in column A and Dates going across row 3. Is there a way to use a create a summary tab using a named range of the worksheets, accounts, and dates, so that if a new country is added all i need to do is update the named range of the worksheets and it will get addded into the total?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Using Named Ranges across multiple worksheets to sum, Arrays
- Thread starter jlario
- Start date
-
- Tags
- array excel namedrange
Similar threads
- Question
