comparing and retrieving value with blank cells

August 6, 2017 at 18:14:21
Specs: Windows 7
Hi, All the expert people out there.
I am stuck in a problem and have tried lots of option but no success.

I have two wheets in one worksheet and I am comparing 2 coulmns to retrieved the value from one into another. screenshot attached

The problem is that the sheet I am retrieving the value from have 2 blank rows and have to skip them.
I am not able to skip and retrieved the right value when ever a blank row is there.

please advise


See More: comparing and retrieving value with blank cells

Reply ↓  Report •

#1
August 7, 2017 at 07:04:32
re: "I have two wheets in one worksheet"

What is a "wheet?" If you meant "sheet", I don't know how you could have 2 sheets in one worksheet. Please explain.

re: "I am comparing 2 coulmns to retrieved the value from one into another"

I don't know what you mean by "comparing columns" as a mean to retrieve a value. You'll need to provide a more details related to your process. Are you using a formula? Are you using a macro? etc.

re: "screenshot attached"

You can't attached a file or image to posts in this forum. You can post an image on a image sharring site, such as imgur.com and post the link back here in the forum or you can upload a file (with all personal/confidential data removed) at a site such as zippyshare.com and then post the link here.

I suggest that you do not use a site that requires us to register because we probably won't.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Reply ↓  Report •
Related Solutions


Ask Question