A simple explanation (I hope) of what I am trying to achieve follows:
I have a macro button that is placed in cell E1 for example that when pressed brings up a form with two text boxes. The information that is entered into these two text boxes is inserted into cell A1 and C1 respectively when OK is pressed.
Now I need to be able to copy this row (including the macro button) to row 4. I want the macro button to behave the same way except I want it to be aware of it's position on the spreadsheet (ie. Row 4) and the values that are entered are placed in cells A4 and C4.
Is there a way for the macro to pick up where in the spreadsheet the button was pressed so that the info entered into the form appears in the correct row?
At the moment I create a 'new' macro each time changing the cell reference which creates more work and more code.
Hope someone can help.
Thanks
Andy
Bookmarks