I currently have a worksheet with a database in it. I can call up the data using the vlookup function. I need a macro that will allow 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 perform a command that will do the following" cell A1=the row number the data is on i.e. row 112. so i need to paste to cell G (a1) or g112 from cell A3. cell A1 changes with each data point so I'm not always copying to G112, the next time it can be G650.