Looking up blank cells and transporting data to another worksheet
 

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

Looking up blank cells and transporting data to another worksheet
 

Hi
see:
http://www.rondebruin.nl/copy5.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Hari" schrieb im Newsbeitrag
...
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

Looking up blank cells and transporting data to another worksheet
 

Hi Frank,

Thanx a lot for leading me in to the right source. Able to what I wanted.

Regards,
Hari
India

"Frank Kabel" wrote in message
...
Hi
see:
http://www.rondebruin.nl/copy5.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Hari" schrieb im Newsbeitrag
...
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