Hi,
I will have two variables with two values,
I want to create a loop that runs through Coloumn A and check for the 1st variable and once found then run through Row B and check for the 2nd variable and then output this value to a new third variable.
I have attached a sample excel sheet. Please help!Sample.xlsx
You say "till the end of the range" but what is the range? I assume you could have more rows? and we can't detect the last row, because the last row is 18 in the example?
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
No sorry, for this example the last row would be 10. I just meant I could have another currency on row 11.
Please Login or Register to view this content.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
another one:
Please Login or Register to view this content.
Thank you, works great!
And another one (when I was learning, I found For Each macros to be a little more literal and easier to understand):
Please Login or Register to view this content.
Another one :
Please Login or Register to view this content.
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks