+ Reply to Thread
Results 1 to 4 of 4

please help on addins for copy selection, paste to a new workbook and edit the title

  1. #1
    Registered User
    Join Date
    12-26-2012
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    38

    Question please help on addins for copy selection, paste to a new workbook and edit the title

    Dear Excel Masters,

    It's been a while since my last question :D Wish you all greatest life ever :D

    To the point, I have a workbook (Excel 2010) with several sheets, on one of it I have some data with formatting and filters. I need to copy the filtered data (by selecting the data) to a new workbook, edit the title and add a total on a cell below the data in the new workbook then save it to a custom name.

    Is it possible to make addins to simplified the task since I have too many data to proccess, if possible, how can I make it??

    Please help, I really need help ASAP... Thank you
    Last edited by ruliansyah; 08-24-2013 at 12:11 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,447

    Re: please help on addins for copy selection, paste to a new workbook and edit the title

    Please show us what you already have and where it went wrong. The purpose of this ( free) forum is not to solve entire projects but to help when you are stuck

  3. #3
    Registered User
    Join Date
    12-26-2012
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    38

    Re: please help on addins for copy selection, paste to a new workbook and edit the title

    Thank you for the reply mr. Pepe Le Mokko,

    Here is part of the macro

    Please Login or Register  to view this content.
    I'm still working with the rest, I just need to know how to convert the macro as an addins so it can be used with any workbook with the same condition...

    Thank you

  4. #4
    Registered User
    Join Date
    12-26-2012
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    38

    Re: please help on addins for copy selection, paste to a new workbook and edit the title

    Anyway, I've figured out myself then... thank you

+ 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. [SOLVED] Macro to copy/paste a title bar row to the bottom of the data set (Different row each day)
    By Gard5096 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-13-2012, 04:36 PM
  2. [SOLVED] Copy Paste Code Edit
    By Alex O in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-08-2012, 11:39 AM
  3. Replies: 1
    Last Post: 03-23-2011, 12:23 AM
  4. Macro to copy a selection, paste it in a new workbook then loop
    By AK262007 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-06-2010, 06:35 AM
  5. Replies: 4
    Last Post: 12-10-2008, 11:43 PM

Tags for this Thread

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