+ Reply to Thread
Results 1 to 3 of 3

Button to "Copy Highlighted Cells and Put them at the end of a list on a different Workshe

  1. #1
    Registered User
    Join Date
    10-16-2017
    Location
    Melbourne, Australia
    MS-Off Ver
    2016
    Posts
    5

    Button to "Copy Highlighted Cells and Put them at the end of a list on a different Workshe

    I hope this is not too difficult.

    I have built a pivot table to summarize a list of products and prices. It would be great if there was a button on the side so I could select records, then press the button to run a code that would paste the selection to another place. Same worksheet or not. It needs to able to run multiple times.

    I know how to create the button, etc. I just need help with the code. I tried recording a macro but I think that was just wishful thinking....

    Thanks

  2. #2
    Registered User
    Join Date
    10-12-2017
    Location
    Brazil
    MS-Off Ver
    2016
    Posts
    59

    Re: Button to "Copy Highlighted Cells and Put them at the end of a list on a different Wor

    Hello.
    I believe that if you post a template of your spreadsheet (with dummy data but the same structure) it will be easier to try to help you.

  3. #3
    Registered User
    Join Date
    10-16-2017
    Location
    Melbourne, Australia
    MS-Off Ver
    2016
    Posts
    5

    Re: Button to "Copy Highlighted Cells and Put them at the end of a list on a different Wor

    Hey Sorry for the delay...

    Here is a template I hope will make sense.

    Much appriciated
    Attached Files Attached Files

+ 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. List Highlighted cells
    By Paul08 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-27-2016, 12:45 PM
  2. [SOLVED] Copy list of cells ignoring cells labelled "Total:"
    By jwillis07 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-22-2014, 07:59 AM
  3. Identify highlighted cells and mark with an "x"
    By nkimball in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-01-2014, 10:19 AM
  4. Excel 2007 : Trying to "Count Highlighted Cells"
    By cegnor in forum Excel General
    Replies: 2
    Last Post: 07-02-2012, 10:08 AM
  5. Command button to print highlighted cells.....
    By shawnmd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-14-2007, 04:42 PM
  6. Replies: 2
    Last Post: 07-06-2005, 02:05 PM
  7. How to delete rows when List toolbar's "delete" isnt highlighted?
    By Linda in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-26-2005, 05:15 PM

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