Skip to Content
0
Former Member
Jun 16, 2016 at 02:12 PM

more AO tables in on sheet

24 Views

Hi All

I have 3 AO tables I want to combine. Example:

AO1: From Cell A1 to A233

AO2: From Cell A233 to A432

AO3: From Cell A432 to A500

When I refresh next month the split will properly be something like this:

AO1: From Cell A1 to A347

AO2: From Cell A347 to A654

AO3: From Cell A654 to A932

Is there any way I can do this automatically?

I use Excel 2010 and AAO 2.2.2