Automate loop in a loop problem

Alternate

New Member
Joined
Feb 21, 2019
Messages
1
Hello there,

I am trying to automate a filter for lottery backtest programme.
I made the VB macro work but with a lot of buttons But it's dragging me behind because I cannot be able to backtest quickly.
I need a loop to automate the process.
I don't know how to loop it


THIS IS WHAT I DO MANUALLY ALL THE TIME.

(backtest ROW link 21 Y143: Y148. below the LEMON GREEN arrow)

# after I execute BUTTON 1, the first matched number is 12 from first row "F53" from E48:E53, F48:F53...
# I manually SUBTRACT 12 from 52
# answer is 40
# CLICK GO DOWN TO SELECT BUTTON
# LOOK 40 on Colum E148: BD148
# 40 is on BB148
# 12 is on the second row so I will have to paste row BA143:BA148. so it can match up.
# click copy and paste button 49 below the RED arrow which will copy and paste it
# then I click the BUTTON 2 which will compare and give the result.

full files available via the link below

https://gator4234.hostgator.com:208...rop=&charset=&file_charset=&baseurl=&basedir=

ACTION AND RESULT
#continue from BUTTON 1
#To be able to loop through E48:E53, F48:F53, G48:G53, HF48:H53, I48:I53 TO BD48:BD53 in that order
# select the first number /Value
#subtract the number from 52 and look for the result on the corresponding columns from E143:BD143,E144:BD144,E145:BD145,E146:BD146,E147:BD147or E148:BD148
#make E48:E53 AS ROW 0 from the first number matched.


Best Regards
Easy Ajibola
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Watch MrExcel Video

Forum statistics

Threads
1,108,987
Messages
5,526,068
Members
409,685
Latest member
Davetom

This Week's Hot Topics

Top