shekar
11-03-2012, 08:01 AM
Hi All,
I have huge excel file which contains lot of data , i want find particular data point and insert blnk row above the data point.
my data as follows
1 Sales Order
2 minute
3 Two
4 second
5 Three
6 Sales Order
7 minute
8 Two
9 second
10 Three
11 Sales Order
12 minute
13 Two
14 second
15 Three
16 Sales Order
17 minute
18 Two
19 second
20 Three
here i want find Sales order and above that i want insert blank row ......i have 15000 data points like this..
I have huge excel file which contains lot of data , i want find particular data point and insert blnk row above the data point.
my data as follows
1 Sales Order
2 minute
3 Two
4 second
5 Three
6 Sales Order
7 minute
8 Two
9 second
10 Three
11 Sales Order
12 minute
13 Two
14 second
15 Three
16 Sales Order
17 minute
18 Two
19 second
20 Three
here i want find Sales order and above that i want insert blank row ......i have 15000 data points like this..