Automatically copy multiple cell VALUES to the cell right below the active cell

**Sarangsood** · 06-16-2011, 05:31 AM

i have a sheet related to stock market where the rates change everyday.
now the cell value at B2 changes everyday and i have to manually copy the VALUE of the cell to the cell right below the active cell in a column. the same goes for 2 more cells ie E2 & H2.

Is there a way that when the cell value changes in B2,E2 and H2 , it automatically copies the value of the cell right below the last active cell .(i have marked the cells to copy with yellow and where to paste the values with green)

thnx

**tigeravatar** · 06-16-2011, 11:29 AM

Sarangsood,

Give this a try:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

**Sarangsood** · 06-17-2011, 12:10 AM

thanks a lot sir ..

just 1 problem , i pasted the above code on 'THIS WORKBOOK' , but when the value changes in B2 it doesnt do anything. its only when i press the RUNSUB button that it copies the value below !!

**tigeravatar** · 06-17-2011, 10:52 AM

Sarangsood,

Don't put it in ThisWorkbook. In the Visual Basic Editor, do Insert -> Module and put the code in there

~tigeravatar

**Sarangsood** · 06-20-2011, 01:36 AM

thanka a lot sir and i appreciate what all u guys do in helping people like me

Automatically copy multiple cell VALUES to the cell right below the active cell

LinkBack

Thread Tools

Rate This Thread

Display

Automatically copy multiple cell VALUES to the cell right below the active cell

Re: Automatically copy multiple cell VALUES to the cell right below the active cell

Re: Automatically copy multiple cell VALUES to the cell right below the active cell

Re: Automatically copy multiple cell VALUES to the cell right below the active cell

Re: Automatically copy multiple cell VALUES to the cell right below the active cell

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions