Paste macro to varible row address

Solved/Closed
Mattcel - Oct 23, 2009 at 02:53 PM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Oct 30, 2009 at 03:10 AM
Hello,
I currently have a worksheet with a data base in it. I can call up the data using the vlookup function. i need a macro that will allow me to replace some data in the data base. i know that what row number the data occurs in and the columns remain fixed. so i need to basciall perform a command that will do the following" cell A1=the row number the data is on ie. row 112. so i need to paste to cell G (a1) or g112 from cell A3. cell A1 changes with each data point so im not always copying to G112, the next time it can be G650

thanks

1 reply

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Oct 30, 2009 at 03:10 AM
Hello
Try this
Sheets("Database").range(sheets("sheet1").range("A1").value).value=sheets("sheet1").range("A3").value

for a button_click event
1