+ Reply to Thread
Results 1 to 3 of 3

Filter data and copy to new sheet and save with data from spreadsheet

  1. #1
    Registered User
    Join Date
    05-13-2007
    Location
    Australia
    MS-Off Ver
    Office365 on Windows10
    Posts
    12

    Filter data and copy to new sheet and save with data from spreadsheet

    I need to be able to filter a spreadsheet received weekly from a supplier (2 weeks sample data attached on separate worksheets) by location in Column A and have that filtered data split into a separate spreadsheet for each location and saved as Location_Start Date.

    For example for week 1 I would end up with 5 spreadsheets saved with the names 1305_24082021, 1306_24082021, 6589_24082021, 7256_24082021, 8423_17082021. And for week 2 there would be 5 spreadsheets named 1045_24082021, 1604_24082021, 5013_24082021, 6089_17082021, 9632_17082021.

    Ultimately looking for a template that the weekly data received can be pasted into so a macro can do the filter, copy/paste & save activity for us. But any solutions would be appreciated.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Filter data and copy to new sheet and save with data from spreadsheet

    Is your profile up-to-date? Are you still using Excel 2007 on WindowsXP?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    05-13-2007
    Location
    Australia
    MS-Off Ver
    Office365 on Windows10
    Posts
    12

    Re: Filter data and copy to new sheet and save with data from spreadsheet

    I’m using Office365 on Windows10.

    I’ll update my profile now. Thanks
    Last edited by AliGW; 08-01-2021 at 04:11 AM. Reason: PLEASE don't quote unnecessarily!

+ 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. VBA scrip to filter spreadsheet, save filtered data and email as attachment
    By Djxela in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-14-2019, 03:57 AM
  2. Excel VBA use userform to filter data and copy filtered data to new sheet
    By reiiling in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-31-2018, 09:36 AM
  3. [SOLVED] Need code to copy data based on filter criteria to new workbook as save in a file location
    By msantucci in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-24-2015, 02:47 AM
  4. Command button to open Save As dialogue box for new spreadsheet and copy data.
    By valhallaone in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-20-2013, 07:08 PM
  5. Copy Data from Multiple weekly Sheet to Monthly sheet and filter the data
    By santhoshjoseph in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-06-2012, 07:07 AM
  6. [SOLVED] MACRO to FILTER data then copy the data to another SHEET.
    By mareuko31 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-15-2012, 08:07 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