+ Reply to Thread
Results 1 to 4 of 4

Edit Macro to export filtered data into separate worksheet instead of PDF

  1. #1
    Registered User
    Join Date
    03-14-2012
    Location
    virginia
    MS-Off Ver
    2007
    Posts
    4

    Edit Macro to export filtered data into separate worksheet instead of PDF

    Hello,

    I have a macro below that currently filters excel data and dumps it into a separate PDF. How can I edit this macro to export the data to another spreadsheet rather than into a PDF?

    Thank you

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by tkowon; 02-07-2014 at 10:31 AM.

  2. #2
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Edit Macro to export filtered data into separate worksheet instead of PDF

    Hi

    Please use code tags first [code] your code here [back slash code]

    It would be great if you provide sample workbook
    Thanks - Naveed
    -----------------------------
    If the suggestion helps you, then Click * to Add Reputation
    To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
    1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

  3. #3
    Registered User
    Join Date
    03-14-2012
    Location
    virginia
    MS-Off Ver
    2007
    Posts
    4

    Re: Edit Macro to export filtered data into separate worksheet instead of PDF

    Thanks, uploaded a test file. Running the macro will parse the sheet into separate pdfs, but looking to parse into separate spreadsheets instead.

  4. #4
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Edit Macro to export filtered data into separate worksheet instead of PDF

    Hi tkowon

    Welcome to the Forum!!

    Try this
    Please Login or Register  to view this content.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

+ 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] Linking cells to filtered results in a separate worksheet
    By excelgreg in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 08-19-2013, 10:47 AM
  2. Combine data from 4 workbooks and then export filtered data to individual files?
    By womanket in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2013, 12:20 PM
  3. Macro that can filter excel data and copy the filtered data to another worksheet
    By glide2131 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-10-2013, 02:43 PM
  4. Macro edit to move data to TWO separate sheets
    By dlab85 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-16-2012, 01:00 PM
  5. [SOLVED] Need Filter+Export to PDF+Delete Filtered Items Macro
    By michaeljoeyeager in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 08-02-2012, 03:38 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