+ Reply to Thread
Results 1 to 1 of 1

Duplicating data on other sheets based on criteria

  1. #1
    Registered User
    Join Date
    12-14-2018
    Location
    Staffordshire, England
    MS-Off Ver
    365
    Posts
    60

    Duplicating data on other sheets based on criteria

    Hi, I am trying to currently take data from one sheet and transfer this data to other sheets based on set criteria whilst then also still being able to insert additional lines manually as and when required on the final sheets!

    On the attached test file the 'Data' sheet would be pulled in from Power Query (it sits on a SP site) and would generally contain a list of in excess of 200 unique numbers each month.

    The idea would then be to move the data to other sheets (in this case simply listed as 'U' & 'L' based on the month and the type - again being either U or L and then listed in date order. There would in reality be several columns of data for each unique number.

    Finally I would then need to be able to insert additional lines when required without affecting any of the other data and maintaining the list as it stands in date order taken from the original data sheet.

    Hope all makes sense,

    Thanks,
    Gaz
    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. [SOLVED] Duplicating sheets and copying data in another workbook
    By Frankie_The_Flyer in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-08-2019, 05:34 AM
  2. Duplicating the data in Excel Based on Certain Criteria
    By anonymous321 in forum Excel General
    Replies: 7
    Last Post: 10-17-2018, 02:32 PM
  3. Replies: 3
    Last Post: 08-25-2016, 12:04 PM
  4. Consolidating the data of all sheets based on criteria
    By laansesu in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-06-2016, 10:37 AM
  5. Replies: 0
    Last Post: 02-24-2016, 04:04 PM
  6. [SOLVED] Pulling Data from two separate sheets based on criteria on both those sheets
    By mlbdc2012 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-31-2015, 03:57 PM
  7. Duplicating/Deleting rows based on criteria
    By excelit in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2013, 09:34 AM

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