Using a macro to delete rows with formula in them

B

baldi

Joined
May 27, 2012
Messages
1
Reaction score
0
I have this table that has blank rows in it. columns ( name, title and shift) have a formula in it =IF(A4>0,VLOOKUP($A4,data,2,FALSE),"")
I need a marco that will delete the rows that are blank and then sort it by draw number
lowest to hights
Number Name Title Shift Pit DRAW NUMBER
2873 Vong, Kiet Supervisor 06:00 44.00
2289 Prochazka, Jiri Dealer 06:00 283.00
8046 Bench, Kevin Dealer 06:00 32.00


4201 Baldinelli, Mark Dual Pit Manager 06:00 75.00
4376 Ballen, Aerol Dealer 06:00 308.00
thanks
 
S

Sohail

Joined
Dec 25, 2014
Messages
2
Reaction score
0
insert a column on very right side, create a formula which will allocate a value "ROWS EMPTY" to that cell which is the part of blank row. after specification blank rows, make a macro, which will first sort the data base with respect to that column so as populated rows will be on top and blank rows will be at bottom, then press control home, find "ROWS EMPTY", press CONTROL+SHIFT+down AERO, delete rows. press cursor on first serial number, allocate numbering and sort the data base as u wish and stop macro.
 
Top