H
Hari
Hi,
I have a sheet by the name "PST summary"
In column B starting from row number 3 to row number x (the value of x is in
cell AX2) I have some alphanumeric data.
Now some of the cells in that range could be BLANK.
In column C, D, E, F, G, H, I and J starting from row number 3 to row number
x(the value of x is in cell AX2) I have some other data. The data in these
cells will nit be blank. (even if it is blank it doesnt matter to me.)
My objective is that in another worksheet "CE" I want to extract those
values in column C, D, E, F, G, H, I and J of worksheet "PST summary"
whenever the corresponding column A of worksheet "PST summary" is BLANK.
For a simple demonstration, here is some sample data in "PST summary"
04-032131 Hari Delhi Point 07-Jun-04 25-Jun-04 16 2 12
04-032131 Kiran Bangalore Deep 07-Jun-04 25-Jun-04 18 2 13
B Delhi Deep 07-Jun-04 25-Jun-04 10 1 7
07-052645 Daya Haryana Kioler 07-Jun-04 25-Jun-04 17 2 13
02-032530 Moori Aurangabad Klustoon Zert 07-Jun-04 25-Jun-04 13 2 9
07-052645 Bruser Pune Juice 07-Jun-04 25-Jun-04 19 2 14
Loiter Pune Quick 07-Jun-04 25-Jun-04 15 2 11
01-000102 Gasace Bangalore Gipet Hoges 07-Jun-04 25-Jun-04 19 2 13
03-097145 Tewri Delhi Leg 17-May-04 21-Jun-04 15 1 14
Punt Haryana Off 17-May-04 21-Jun-04 15 1 14
The above data starts from Column B3 and extends to J12. (here x is equal to
12 but it will change depending on the conditions and value of x is in cell
AX2)
Now in the worksheet "CE" starting from row 3 and column C, I want the data
from worksheet "PST summary" whenever Column B is blank.
Like in the above sample data record numbers 3, 7 and 10 are blank hence the
display in worksheet "CE" will be
B Delhi Deep 07-Jun-04 25-Jun-04 10 1 7
Loiter Pune Quick 07-Jun-04 25-Jun-04 15 2 11
Punt Haryana Off 17-May-04 21-Jun-04 15 1 14
Please guide me on how to achieve the same.
Regards,
Hari
India
I have a sheet by the name "PST summary"
In column B starting from row number 3 to row number x (the value of x is in
cell AX2) I have some alphanumeric data.
Now some of the cells in that range could be BLANK.
In column C, D, E, F, G, H, I and J starting from row number 3 to row number
x(the value of x is in cell AX2) I have some other data. The data in these
cells will nit be blank. (even if it is blank it doesnt matter to me.)
My objective is that in another worksheet "CE" I want to extract those
values in column C, D, E, F, G, H, I and J of worksheet "PST summary"
whenever the corresponding column A of worksheet "PST summary" is BLANK.
For a simple demonstration, here is some sample data in "PST summary"
04-032131 Hari Delhi Point 07-Jun-04 25-Jun-04 16 2 12
04-032131 Kiran Bangalore Deep 07-Jun-04 25-Jun-04 18 2 13
B Delhi Deep 07-Jun-04 25-Jun-04 10 1 7
07-052645 Daya Haryana Kioler 07-Jun-04 25-Jun-04 17 2 13
02-032530 Moori Aurangabad Klustoon Zert 07-Jun-04 25-Jun-04 13 2 9
07-052645 Bruser Pune Juice 07-Jun-04 25-Jun-04 19 2 14
Loiter Pune Quick 07-Jun-04 25-Jun-04 15 2 11
01-000102 Gasace Bangalore Gipet Hoges 07-Jun-04 25-Jun-04 19 2 13
03-097145 Tewri Delhi Leg 17-May-04 21-Jun-04 15 1 14
Punt Haryana Off 17-May-04 21-Jun-04 15 1 14
The above data starts from Column B3 and extends to J12. (here x is equal to
12 but it will change depending on the conditions and value of x is in cell
AX2)
Now in the worksheet "CE" starting from row 3 and column C, I want the data
from worksheet "PST summary" whenever Column B is blank.
Like in the above sample data record numbers 3, 7 and 10 are blank hence the
display in worksheet "CE" will be
B Delhi Deep 07-Jun-04 25-Jun-04 10 1 7
Loiter Pune Quick 07-Jun-04 25-Jun-04 15 2 11
Punt Haryana Off 17-May-04 21-Jun-04 15 1 14
Please guide me on how to achieve the same.
Regards,
Hari
India