Search : in
By :

Paste macro to varible row address

Last answer on Oct 30, 2009 7:10:54 am GMT Mattcel, on Oct 23, 2009 7:53:20 pm BST 
 Report this message to moderators

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

Configuration: Windows XP Internet Explorer 6.0

Best answers for « paste macro to varible row address » in :
Excel – Macro to detect and hide blank rows ShowExcel – Macro to detect and hide blank rows Issue Solution Note Issue I want a macro to unhide about 20 blank rows copy values into the top row then hide the remaining rows (some cells have fill though) then the next time it will...
Swapping two variables without using a temp variable ShowSwapping two variables without using a temp variable Using pointers Making use of a Macro Using pointers #include void change(int *,int*); int main () { int a=2,b=5; printf("Before : a=%d,b=%d\n",a,b); ...
Excel – Macro for copy & paste selected range ShowExcel – Macro for copy & paste selected range Issue Solution Note Issue I have a summary of data by month in one sheet and the raw data in another sheet. Instead of creating multiple worksheets for my raw data for each month, I want...
Environment variables ShowEnvironment variables An environment variable is a dynamic value loaded into the memory that can be used by several processes operating simultaneously. On most operating systems, the location of some libraries or of the main system executables may...
NAT- Network address translation, port forwarding and port trigg ShowThe principle of NAT Network address translation or NAT was developed in order to respond to the shortage of IP addresses with IPv4 protocol (in time the IPv6 protocol will respond to this problem). In fact, in IPv4 addressing the number of...
IP Address ShowWhat is an IP address? Computers communicate over the Internet using the IP protocol (Internet Protocol), which uses numerical addresses, called IP addresses, made up of four whole numbers (4 bytes) between 0 and 255 and written in the format...
Ask your question Reply

1

 Excelguru, on Oct 30, 2009 7:10:54 am GMT

Hello
Try this
Sheets("Database").range(sheets("sheet1").range("A1").value).value=sheets("sheet1").range("A3").value

for a button_click event A wise man once said, 'I complained that I had no shoes until I met a man who had no feet.'
I am interested in financial Modelling and custom excel development with excel macros.

   
Reply to Excelguru
Ask your question Reply
They need your help