Multi Worksheets get Columns to match

Purfleet · #1 10-26-2020, 04:56 AM

Use this one so the clear all doesnt kill the green boxes! Only done it quickly so check it.

We can sort out formatting in version 2

and deleting a child is in version 2

dlafko1 · #2 10-26-2020, 05:32 AM

So not sure this matters since we will never have just 1 kid but thought i would let you know.

In combined profit if you add just 1 child then it drops the row 2 down rather than the equations picture attached

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Comparing between 2 worksheets and retreiving data if a match	FUGMAN	Excel Programming	8	02-18-2017 09:47 AM
Counting only the unique names in 3 columns on separate worksheets.	Ryga38	Excel	1	04-15-2016 07:21 AM
Match Multi Cells	gdavey	Excel Programming	1	09-06-2015 11:09 AM
Index Match Function across different worksheets	shay_mt	Excel	2	04-27-2015 06:04 AM
Multi Level Subtotals w 2 Grand Totals That Don't Match	DavidW	Excel	3	10-09-2014 07:08 AM