Multi Worksheets get Columns to match

Purfleet · #1 10-22-2020, 11:46 AM

A Couple of things - there is only 1 sheet on the attached and its not got anynames on it

and most importantly the merged cells in a1 & b1 have to go!

dlafko1 · #2 10-22-2020, 11:52 AM

Sorry Wrong Workbook.

The Take order is where it gets complicated.

Need cells B4 to AA 4 to shift down when a new name is added and to move calculations with it. While keeping the rest of the columns to the right of AA4 in tact.

If you do messenger or email might be quicker LOl

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