Use data from another worksheet, calculate, then advance +1 worksheet, repeat 150 times

[MrLearningalot]

I have a sequence of worksheets, each one represents one month. On all the worksheets there is a list of stocks and their prices at month end in column A then B respectively.

I'm wanting to show what the % return each stock is getting for one month in column C, 2 months in column D, and three month % return in column E. This suggests that worksheet 4 will be able to present this data, so from worksheet 4 to 150 I need these calculated.

I'm struggling with the code needed to select the proper worksheet than repeating the process with +1 worksheet, if you know what I mean. Selecting the previous worksheet when recording a macro just selects that specific worksheet, so I need a better way.

Any help would be appreciated,

Thanks

 

[Smitty]

Welcome to the Board!

How about posting the code you have so far? From there someone will be able to do what you want.