Hi,

I've had to move from a data system where I could block data that meets a criteria I set and am looking to replicate this functionality in Excel.

With the example source data (1st table) below I'd like to run a macro that ideally moves Q one cell to the right (the column is otherwise blank) if the below criteria are met (2nd post) under the header references.

If this is possible, I'd really like to understand how to amend the code to add into the 'block list', vary headers etc.

Excel 2010
Row\Col
E
F
G
H
I
J
K
L
M
Q
1
 EMART OPERATIONAL CONTROL ELEMENT UOM DATE Calender Year Financial Year Data source Data type Q
152613
 GWA 11100 - Greases - Petroleum based (Stationary) LT
Jan-16
2016
 2015-16 JDE X central
418
152614
 GWA 11000 - Diesel automotive (Stationary) LT
Feb-16
2016
 2015-16 JDE X central
5168
152615
 GWA 11000 - Diesel automotive (Stationary) LT
Feb-16
2016
 2015-16 JDE X central
5881
152618
 GWA 11000 - Diesel automotive (Stationary) LT
Jan-16
2016
 2015-16 JDE X central
4602
153062
 GWA 11100 - Greases - Petroleum based (Stationary) LT
Jan-16
2016
 2015-16 JDE X central
209
153063
 GWA 11110 - Petroleum Oils (Stationary) KG
Jan-16
2016
 2015-16 JDE X central
22
153064
 GWA 11100 - Greases - Petroleum based (Stationary) LT
Jan-16
2016
 2015-16 JDE X central
1,000
153065
 GWA 11100 - Greases - Petroleum based (Stationary) LT
Jan-16
2016
 2015-16 JDE X central
1,000
153066
 GWA 11100 - Greases - Petroleum based (Stationary) LT
Jan-16
2016
 2015-16 JDE X central
209
153147
 F2E 11110 - Petroleum Oils (Stationary) LT
Feb-16
2016
 2015-16 JDE X central
1000
153148
 F2E 11110 - Petroleum Oils (Stationary) LT
Feb-16
2016
 2015-16 JDE X central
960
153149
 F2E 11000 - Diesel automotive (Stationary) LT
Feb-16
2016
 2015-16 JDE X central
33311
153150
 F2E 11000 - Diesel automotive (Stationary) LT
Jan-16
2016
 2015-16 JDE X central
34442
153335
 GWA 11000 - Diesel automotive (Stationary) LT
Feb-16
2016
 2015-16 JDE X central
4180
153416
 F2E 11000 - Diesel automotive (Stationary) LT
Jan-16
2016
 2015-16 JDE X central
757
153565
 GWA 11000 - Diesel automotive (Stationary) LT
Feb-16
2016
 2015-16 JDE X central
4590
153566
 GWA 11000 - Diesel automotive (Stationary) LT
Jan-16
2016
 2015-16 JDE X central
4494.17
153762
 GWA 11000 - Diesel automotive (Stationary) LT
Jan-16
2016
 2015-16 JDE X central
4983.93
153813
 F2E 11100 - Greases - Petroleum based (Stationary) LT
Jan-16
2016
 2015-16 JDE X central
209
153814
 F2E 11000 - Diesel automotive (Stationary) LT
Jan-16
2016
 2015-16 JDE X central
34532
153816
 F2E 11000 - Diesel automotive (Stationary) LT
Feb-16
2016
 2015-16 JDE X central
1303.6
Sheet: SOURCE