Find Value from Column B if Column N is blank or zero in same row

[kalasha]

Good afternoon,

I am looking for a few lines of code that takes the values from Column B if the value in Column N is either Blank or zero

Please Login or Register  to view this content.

Example: Cell N15 is blank, the Value in cell B15 is "Store 123" I need "Store 123" to be stored in LocationID. It is possible that there could be no cells or multiple cells that will be zero/blank. Only the first one needs to be captured. Since the code can be run manually, the user can press the button multiple times to find additional zero/blank fields.

Thank you,

K.

[alansidman]

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[kalasha]

works and understood - thank you.

[sintek]

It is possible that there could be no cells or multiple cells that will be zero/blank.

Only the first one needs to be captured

So what happens if their are none...
What happens if there are multiple...Only the first one needs to be captured...

Since the code can be run manually, the user can press the button multiple times to find additional zero/blank fields.

If you run code that doesn't edit the first one found then that one is always going to be first...one found

So perhaps upload a sample file and explain in detail what must happen each time this supposed code is run...

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[kalasha]

Good afternoon,

I replied earlier but I see that my reply was not posted/saved. Sometimes, when I post my complete desired result, the contributor provides the complete code. For the contributor it's 10 minutes on a keyboard, for me it's 10 seconds to cut/paste and move on without understanding/appreciating what is happening in the code. In your comments you pointed out something that I did not think of - exit my For/If loop or the sub. So I came up with the following:

Please Login or Register  to view this content.

My subs will do the following:
Search the Template tab for zero or blank cells in Column N (between two rows) - complete
Find the Location ID (on the row where the blank/zero values is in Column N) - complete with your line of code

Last, I will be going through each visible tab and deleting any rows where the LocationID appears. For that I will be passing the variable LocationID to another sub that will loop through visible sheets and delete any rows where LocationID is present. Currently, I was using an input box to capture user input, but that can be prone to user error. So I am in the process of automating this.

Thank you,

[sintek]

I am very certain that these two processes can be combined ... or ... just simplified with one snippet of code...Can only say once you upload a sample file depicting your actual setup and explain the process in more detail...