+ Reply to Thread
Results 1 to 2 of 2

Duplicate worksheet but link future changes

Hybrid View

  1. #1
    Registered User
    Join Date
    07-10-2014
    Location
    washington d. c.
    MS-Off Ver
    2010
    Posts
    2

    Question Duplicate worksheet but link future changes

    I have a worksheet where I am following the status of my products (pending, finalized, in process, etc.) I want to have a separate worksheet just for the finalized products but I want it to "autoupdate" from the main worksheet where I have all products so I dont have to add it manually to both worksheet. For knowwhat I've been doing is duplicating the worksheet from time to time and filtering the Finalized products in the second sheet, but that's not a very efficient idea. Any suggestions?

    (I dont want to use a pivot)

  2. #2
    Forum Contributor stephenloky's Avatar
    Join Date
    07-10-2013
    Location
    Sao Paulo - Brazil
    MS-Off Ver
    Excel 2007
    Posts
    146

    Re: Duplicate worksheet but link future changes

    =COUNTIF(RANGE,"Finalized")
    ?
    "The quieter you become, the more you are able to hear"

    Any reputation (*) points appreciated.

    "If you know yourself but not the enemy, for every victory gained, you will suffer defeat."

+ 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. Hide Future Rows Containing Future Dates.
    By Raj_121 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-27-2013, 07:14 AM
  2. [SOLVED] Compare strings for match in separate worksheet and return nearest future date
    By kungfood in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-05-2012, 05:19 PM
  3. How to make a worksheet the standard format for future worksheets?
    By cody4334 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-13-2012, 12:10 AM
  4. Best Way to Export a Single Worksheet for Future Import?
    By Samuel K in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-26-2012, 12:33 PM
  5. need an income statement forecasting worksheet for future years
    By top gun in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-28-2005, 09:30 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