I will take a guess that you want to open the files.
I am assuming that columns always go to column U. If that is not the case, then you need to make the last column dynamic if the columns used can vary for different files. ( If you need to do that, and can’t figure out how, then I will do that for you later, probably tomorrow )

I have used the same ways as I did in the last macro for you, ( to solve Problem 2 https://excelfox.com/forum/showthrea...ll=1#post14648 )

I do not delete any rows
Instead I collect indices of the rows you want to have = rows which are not to be deleted. For you test data, the rows you want are 2 3 and 4
Finally the macro replaces the original range with a new one containing just the rows you want

Before

_____ Workbook: Book2.xlsx ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
1
2
 NSE EQ BAJAJ NA NA NA
0
12
0
 SELL MARKET NA CLI MIS DAY WC5758 NA
3
 NA
3
 NSE EQ AMARAJABAT NA NA NA
0
12
0
 SELL MARKET NA CLI MIS DAY WC5758 NA
3
 NA
4
 NSE EQ ASIANPAINT NA NA NA
0
12
0
 SELL MARKET NA CLI MIS DAY WC5758 NA
3
 NA
Worksheet: Sheet1

_____ Workbook: Book1.xlsx ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
1
2
 NSE EQ ADANIPOWER NA NA NA
0
12
0
 SELL MARKET NA CLI MIS DAY WC5758 NA
3
 NA
3
 NSE EQ AMARAJABAT NA NA NA
0
12
0
 SELL MARKET NA CLI MIS DAY WC5758 NA
3
 NA
4
 NSE EQ ASIANPAINT NA NA NA
0
12
0
 SELL MARKET NA CLI MIS DAY WC5758 NA
3
 NA
Worksheet: Sheet1


After

_____ Workbook: Book2.xlsx ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
1
 NSE EQ BAJAJ NA NA NA
0
12
0
 SELL MARKET NA CLI MIS DAY WC5758 NA
3
 NA
2
 NSE EQ AMARAJABAT NA NA NA
0
12
0
 SELL MARKET NA CLI MIS DAY WC5758 NA
3
 NA
3
 NSE EQ ASIANPAINT NA NA NA
0
12
0
 SELL MARKET NA CLI MIS DAY WC5758 NA
3
 NA
4
Worksheet: Sheet1

_____ Workbook: Book1.xlsx ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
1
 NSE EQ ADANIPOWER NA NA NA
0
12
0
 SELL MARKET NA CLI MIS DAY WC5758 NA
3
 NA
2
 NSE EQ AMARAJABAT NA NA NA
0
12
0
 SELL MARKET NA CLI MIS DAY WC5758 NA
3
 NA
3
 NSE EQ ASIANPAINT NA NA NA
0
12
0
 SELL MARKET NA CLI MIS DAY WC5758 NA
3
 NA
4
Worksheet: Sheet1

Macro here https://excelfox.com/forum/showthrea...ll=1#post14657



Note: You must change this line
Code:
 Let arrWbs() = Array(ThisWorkbook.path & "\Book1.xlsx", ThisWorkbook.path & "\Book2.xlsx") ' - CHANGE TO SUIT
To something like this
Code:
 Let arrWbs() = Array("C:\Users\WolfieeeStyle\Book1.xlsx", "C:\Users\WolfieeeStyle\Desktop\Book2.xlsx", "C:\Users\Desktop\MyBook.xlsx")  '