Thread: how should i combine named formulas with a macro

Hello fellow lovers of excel, attached file is supposed to do the following:

THe macro AddReport:
--creates new sheet for report (works)
--initialize data on new sheet (works)
--create a new named formula for the data on the page (works)
--updates a cummulative named formula to combine all the ranges togeter (nope, don't work)

I'm just not sure how to combine named ranges (formulas). I have 2 tables in the attachment and want the named formula for CUmmTable to be the "combined table" from Ptable1 and Ptable2

By combined i mean i want all the rows treated as if they were part of one table.

How do you combine 2 tables defined similar to this: =$A$2:INDEX($1:$1048576,counta($A:$A),counta($1:$1))

Thank you

>>bump bump bump<<

>>hello again<<

To get a feel for what I want assume one named formula (PTable1) represents 3 rows of data and another named formula represents 2 rows of data. I'm looking for a way to combine them to a table with 5 rows of data.


PTable1
A B C
E F G
H I J

PTable2
1 2 3
4 5 6

Ptable1 "+" Ptable2

A B C
E F G
H I J
1 2 3
4 5 6

-------

Example attached.


--------

Usually i macro summaries and I'm just playing with the idea of collecting together named ranges to somehow to allow a summary table to auto-update w/o the need for a macro.