+ Reply to Thread
Results 1 to 2 of 2

Copy Sheet to function independently

  1. #1
    Registered User
    Join Date
    07-01-2021
    Location
    Texas
    MS-Off Ver
    Excel 365
    Posts
    3

    Copy Sheet to function independently

    I have a report that pulls in information from various tables. This report can be filtered by different sections. I'm trying to create new sheets copied from original, to break down each section on it's own sheet.
    My issue is, I can copy and paste but once I filter the original sheet, the other sheets filter data to whatever is on original sheet.

    How can I keep the copied sheets to filter independently and not revert to original sheet changes?


    For example.

    I have a job that has different sections (i.e. plumbing, electrical, AC) I want to create a new sheet tab for each of these sections so they show their own costs but I want each tab to stay on that section, not change when i work on the original sheet.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,415

    Re: Copy Sheet to function independently

    Hi there.

    A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

    Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help 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. Copy to last empty row (independently of A column)
    By Mr.Kaja in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-30-2019, 02:46 AM
  2. [SOLVED] Copy data without using copy function from sheet 1 to sheet 2
    By SANKARTUDU in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-10-2014, 08:52 PM
  3. Function to copy cell contents from sheet 1 to sheet 2
    By cameron213 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-26-2014, 08:13 PM
  4. If/then LookUp Function or a Function to copy data for sheet to sheet
    By imdavenp85 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-26-2008, 10:21 AM
  5. [SOLVED] Function that will copy sheet to sheet IF...
    By underdog in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-03-2006, 01:50 PM
  6. how to sort many rows independently?
    By guillemot in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-28-2005, 12:51 PM
  7. Can you sort rows independently?
    By JXie in forum Excel General
    Replies: 2
    Last Post: 03-24-2005, 12:51 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