Range auto select

[hamking01]

I have an excel sheet that contains a form that keeps repeating itself in the same format vertically. I'm trying to copy each of the forms data onto a seperate sheet listing each form my row.

Will I be able to the the following via VBA:
If I click on the top left corner of each form I click a button that sets that cell as the Current Region (There a 5 blank rows between each form). From the clicked cell I need it to move 5 columns to the right and 2 rows down and copy the data from the cell to cell A100. It will then move from starting point cell of form and move to different cell and copy data to cell B100.

Basically I'm trying to copy info from each form into a row format, where each row will have the info for one form. Can anyone tell me how this can be done?

 

[BattleDroid42]

The key to figuring out any coding problem in Excel is to record the steps you would take manually and then look at the macro code that's generated. You can add variables and expand the code from there. In general, if you can do it manually, you can do it in code.

Remember, wherever you go...there you are.