+ Reply to Thread
Results 1 to 5 of 5

Vba code for auto filter, copy, paste and save to new sheet

  1. #1
    Registered User
    Join Date
    12-25-2015
    Location
    Delhi, India
    MS-Off Ver
    2007
    Posts
    17

    Vba code for auto filter, copy, paste and save to new sheet

    Hi All,

    Greetings for the day!

    I need to do repetitive task for filtering dealer payment data zone wise. my workbook (Dummy file) is having unique value for filter in column D named "zone". on the basis of these zones I need to create files zone-wise with name "payment file Silchar(zone name) dd-mm-yyyy(current date)". file to be save having name of that zone and the date (current date). this is to be done for every unique zones.
    I am sharing the macros for one zone as below. Header of this file is having first two rows merged. in this macros, header is not copied, don't know why. please see the code and suggest how to do it for other zones and files/workbook should be saved in any other destination on my system.
    I can also upload the file, not getting any option for the same. Please

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Hanky; 02-22-2018 at 07:17 AM.

  2. #2
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Vba code for auto filter, copy, paste and save to new sheet

    Hi Hanky- Per forum rule #3, please edit your post to include Code Tags. This will improve readability across different platforms.
    Just click Edit Post, select your code text and click # on the Editing Toolbar. Thanks - Lee
    Last edited by leelnich; 02-22-2018 at 02:12 AM.
    Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
    Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee

  3. #3
    Registered User
    Join Date
    12-25-2015
    Location
    Delhi, India
    MS-Off Ver
    2007
    Posts
    17

    Re: Vba code for auto filter, copy, paste and save to new sheet

    Quote Originally Posted by leelnich View Post
    Hi Hanky- Per forum rule #3, please edit your post to include Code Tags. This will improve readability across different platforms.
    Just click Edit Post, select your code text and click # on the Editing Toolbar. Thanks - Lee
    Hi Leelnich,

    Thanks for guiding, same has been done.

  4. #4
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Vba code for auto filter, copy, paste and save to new sheet

    Thank you, and yes, a sample workbook would be helpful.

    To attach a workbook:
    Click Edit Post (or just start a new reply.)
    Click Go Advanced
    Scroll down to Manage Attachments and click.
    Now click Browse, find your file, then click Upload. Simple!

  5. #5
    Registered User
    Join Date
    12-25-2015
    Location
    Delhi, India
    MS-Off Ver
    2007
    Posts
    17

    Re: Vba code for auto filter, copy, paste and save to new sheet

    Quote Originally Posted by leelnich View Post
    Thank you, and yes, a sample workbook would be helpful.

    To attach a workbook:
    Click Edit Post (or just start a new reply.)
    Click Go Advanced
    Scroll down to Manage Attachments and click.
    Now click Browse, find your file, then click Upload. Simple!
    Hi Leelnich,

    I had attached my sample file, file name is "Dummy File". Thanks again.

+ 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, paste visible cells after Auto filter- VBA
    By meus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-31-2015, 01:59 AM
  2. macro to auto filter and then paste certain columns to another sheet
    By alwinaz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2014, 09:06 AM
  3. VBA Code to filter,Copy and Paste data from one sheet to the other
    By aravindkm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-18-2013, 03:39 PM
  4. VB code to filter copy and paste in a different sheet
    By rshnkmr39 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-26-2013, 12:53 AM
  5. Filter-Copy Paste-Save sheet-Delete info
    By srikanthbenoni in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-28-2012, 06:08 AM
  6. Auto-Paste Data on save to Another Sheet
    By tariqnaz2005 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-14-2009, 08:36 AM
  7. need code for copy/paste, highlighting columns and enabling auto-filter/freeze panes
    By excelaspire0219 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-09-2009, 05:45 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