+ Reply to Thread
Results 1 to 5 of 5

(Urgent Req) VBA code required to paste values ON visible cells (Or filtered rows) only

  1. #1
    Forum Contributor
    Join Date
    09-20-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    275

    (Urgent Req) VBA code required to paste values ON visible cells (Or filtered rows) only

    Dear all,
    Please review the attached excel file.
    It has 3 sheets, "OLD values", "New Values" and "OUTPUT"

    I want new values under column 'B:B' from 'New values' sheet, to be pasted upon old values under Column D:D of 'OLD values' sheet.

    But please note: Column D:D in 'OLD values' sheet has filtered rows.

    Please dont include headers and any color formatting into your code.

    'OUTPUT' sheet has the output that i am looking for (Just for your reference).

    Note: This thread is a follow-on for below,

    http://www.excelforum.com/excel-prog...ells-only.html
    Attached Files Attached Files
    Last edited by mchilapur; 01-16-2015 at 12:44 PM.

  2. #2
    Forum Contributor
    Join Date
    03-04-2014
    Location
    Canada Eh
    MS-Off Ver
    Excel 2010
    Posts
    199

    Re: (Urgent Req) VBA code required to paste values ON visible cells (Or filtered rows) onl

    Just place the following V-Lookup into your cell at D25
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    and then copy down.
    Click the * to give Rep to a post you like.

  3. #3
    Forum Contributor
    Join Date
    09-20-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    275

    Re: (Urgent Req) VBA code required to paste values ON visible cells (Or filtered rows) onl

    I can't use this because I already have some functions in 'OLD values' sheet, Column D:D.
    I want it to be done through VBA. Also I want to put this code into my existing macro.

  4. #4
    Forum Contributor
    Join Date
    09-20-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    275

    Re: (Urgent Req) VBA code required to paste values ON visible cells (Or filtered rows) onl

    Anyone working on my request..???

  5. #5
    Forum Contributor
    Join Date
    09-20-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    275

    Re: (Urgent Req) VBA code required to paste values ON visible cells (Or filtered rows) onl

    Any updates...? Please look into my concern....Please....

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy visible cells in filtered table and paste in userform textbox - email
    By pfeifferjoey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-29-2014, 11:23 AM
  2. Paste Visible Cells in Filtered 2010 Spreadsheet
    By vhouston in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-09-2013, 10:44 AM
  3. Replies: 3
    Last Post: 04-11-2013, 04:13 AM
  4. Adjust Code to Loop through Visible(filtered) cells only
    By enidnunez in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-19-2013, 09:23 AM
  5. Copy Visible cells and paste values only to visible target cells
    By wotadude in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-28-2010, 04:09 AM

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