insert column and autofill based on cell value

[Ali M]

Hello I would insert column after column B and auto fill name until lastrow with ignore TOTAL row based on H1

DD.xlsm
	A	B	C	D	E	F	G	H
1	DATE	DETAILS	SAFES	DEBIT	CREDIT	BALANCE		ALI
2	20/03/2024	SALES INVOICE	BANK	3100	0	3100
3	20/03/2024	SALES INVOICE	SHOP SAFE	4800	0	7900
4	20/03/2024	SALES INVOICE	HOME SAFE	4200	0	12100
5	20/03/2024	RECEIVED CASH	BANK	3000	0	15100
6	20/03/2024	PAID CASH	SHOP SAFE	0	4400	10700
7	20/03/2024	PAID CASH	HOME SAFE	0	2700	8000
8	21/03/2024	SALES INVOICE	SHOP SAFE	1000	0	1000
9	21/03/2024	SALES INVOICE	HOME SAFE	1200	0	2200
10	21/03/2024	PAID CASH	SHOP SAFE	0	2200	0
11	21/03/2024	RECEIVED CASH	HOME SAFE	10000	1100	8900
12	22/03/2024	RECEIVED CASH	BANK	3000	0	3000
13	23/03/2024	RECEIVED CASH	HOME SAFE	2000	0	2000
14	23/03/2024	RECEIVED CASH	BANK	5000	0	7000
15	23/03/2024	PAID CASH	SHOP SAFE	3000	0	10000
16	TOTAL			0	0	29900
A

Cell Formulas
Range	Formula
D16:E16	D16	=SUM(L2:L15)

RESULT

DD.xlsm
	A	B	C	D	E	F	G	H	I
1	DATE	DETAILS	NAME	SAFES	DEBIT	CREDIT	BALANCE		ALI
2	20/03/2024	SALES INVOICE	ALI	BANK	3100	0	3100
3	20/03/2024	SALES INVOICE	ALI	SHOP SAFE	4800	0	7900
4	20/03/2024	SALES INVOICE	ALI	HOME SAFE	4200	0	12100
5	20/03/2024	RECEIVED CASH	ALI	BANK	3000	0	15100
6	20/03/2024	PAID CASH	ALI	SHOP SAFE	0	4400	10700
7	20/03/2024	PAID CASH	ALI	HOME SAFE	0	2700	8000
8	21/03/2024	SALES INVOICE	ALI	SHOP SAFE	1000	0	1000
9	21/03/2024	SALES INVOICE	ALI	HOME SAFE	1200	0	2200
10	21/03/2024	PAID CASH	ALI	SHOP SAFE	0	2200	0
11	21/03/2024	RECEIVED CASH	ALI	HOME SAFE	10000	1100	8900
12	22/03/2024	RECEIVED CASH	ALI	BANK	3000	0	3000
13	23/03/2024	RECEIVED CASH	ALI	HOME SAFE	2000	0	2000
14	23/03/2024	RECEIVED CASH	ALI	BANK	5000	0	7000
15	23/03/2024	PAID CASH	ALI	SHOP SAFE	3000	0	10000
16	TOTAL				0	0	29900
A

Cell Formulas
Range	Formula
E16:F16	E16	=SUM(M2:M15)

when run the macro I don't repeat insert column every time
thanks

 

[Ali M]

Awesome !
thank you so much.

 

[mumps]

You are very welcome.

 

[Ali M]

after insert column will change formulas in location .
can you add formulas in TOTAL lastrow by sum column E,F and in column G=E-F
thanks again.

 

[mumps]

after insert column will change formulas in location

If the formulas already exist in the TOTAL last row, when a new column is inserted, the formulas should adjust automatically.

 

[Ali M]

Yes you're right.
thanks again for confirmation.

 

[mumps]

My pleasure.