I am new to Macros I have the following
I need a macro that will take a cell with a number say 5 and another cell in the same row with a number say 10 and produce on another spreadsheet with the rows
5
6
7
8
9
10
This will need to do the same thig for about 500 rows of data. So for example i would have the following rows
F H
13175910 13175911
15356150 15356156
15356280 15356281
15356405 15356406
15356530 15356531
15356655 15356656
After running the maco sheet 2 would have
A
13175910
13175911
15356150
15356151
15356152
15356153
15356154
15356156
15356280
15356281
15356405
15356406
15356530
15356531
15356655
15356656
15356150

MUCH appriciate any help