Loop through last row to return a value based on value of current cell

**sammar12** · 07-07-2016, 11:03 AM

I have an extensive macro I run that I need to add some code to. For some reason it worked yesterday, today it does not. I need to find the last row of a spreadsheet that will change daily. I need to loop through column 10 if the value is a "B", it should grab the value of column 8, if it is a "W" it should grab the value of column 9, anything else it should leave blank.

here is what I have

Please Login or Register  to view this content.

**AB33** · 07-07-2016, 11:17 AM

Why are you looping backwards, not forwards as you are not inserting to deleting rows?
Filter is much more faster than a loop. Please attach a sample and will do a better code.

**stnkynts** · 07-07-2016, 11:23 AM

To add to what AB33 said you may look to simplify things by putting a formula in column D rather than use a macro. Here is what i think you are trying to do

Please Login or Register  to view this content.

**sammar12** · 07-07-2016, 12:04 PM

Originally Posted by AB33

Why are you looping backwards, not forwards as you are not inserting to deleting rows?
Filter is much more faster than a loop. Please attach a sample and will do a better code.

I have attached a file and changed my code, since I had an instruction that has nothing to do with this code left in from a previous code I took this from.

Please Login or Register  to view this content.

**AB33** · 07-07-2016, 12:08 PM

Have you tried stnkynts' code?
Where do you want to copy the data in to where is a match of B and W? Which columns?

**AB33** · 07-07-2016, 12:21 PM

From your code, this is probably correct.

Please Login or Register  to view this content.

stnkynts' code

Please Login or Register  to view this content.

**sammar12** · 07-07-2016, 01:13 PM

Thanks for the help!

Loop through last row to return a value based on value of current cell

LinkBack

Thread Tools

Rate This Thread

Display

Loop through last row to return a value based on value of current cell

Re: Loop through last row to return a value based on value of current cell

Re: Loop through last row to return a value based on value of current cell

Re: Loop through last row to return a value based on value of current cell

Re: Loop through last row to return a value based on value of current cell

Re: Loop through last row to return a value based on value of current cell

Re: Loop through last row to return a value based on value of current cell

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Select Value in current cell while in a Loop

[SOLVED] Pick a cell containing current month actulas based what the current month is.

[SOLVED] check cell above current cell in loop

[SOLVED] Date Formula to Return Week Number in Current Month based on Reporting Period

[SOLVED] I need to look up the current date and return a value based on specific criteria

[SOLVED] Macro to return to Current Sheet and Cell

return dynamic current active cell!!

Bookmarks

Bookmarks

Posting Permissions