+ Reply to Thread
Results 1 to 5 of 5

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

  1. #1
    Forum Contributor
    Join Date
    05-18-2011
    Location
    Delhi , India
    MS-Off Ver
    Excel 2007
    Posts
    171

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

    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
    Attached Files Attached Files
    Last edited by Sarangsood; 06-20-2011 at 01:37 AM.

  2. #2
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

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

    Sarangsood,

    Give this a try:
    Please Login or Register  to view this content.


    Hope that helps,
    ~tigeravatar

  3. #3
    Forum Contributor
    Join Date
    05-18-2011
    Location
    Delhi , India
    MS-Off Ver
    Excel 2007
    Posts
    171

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

    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 !!

  4. #4
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

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

    Sarangsood,

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

    ~tigeravatar

  5. #5
    Forum Contributor
    Join Date
    05-18-2011
    Location
    Delhi , India
    MS-Off Ver
    Excel 2007
    Posts
    171

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

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1