+ Reply to Thread
Results 1 to 2 of 2

Making data automatically flow to other worksheets based on one cell

  1. #1
    Registered User
    Join Date
    01-11-2015
    Location
    Clayton, NC
    MS-Off Ver
    10
    Posts
    1

    Making data automatically flow to other worksheets based on one cell

    Hi! Excel novice and I’m trying to figure out how I can get data from one master log to automatically flow into a separate worksheet based on the "state" designation. So, whenever I am on the master log worksheet and I enter something for PA I would like that entire row to automatically show up under the PA tab as well. I realize filtering is a quick fix but I’d like to be able to see the info on different tabs. Is there any easy way to do this?

    Thanks!!
    Brittany
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Making data automatically flow to other worksheets based on one cell

    I think something like the attached workbook will help. You'll just have to go in and change the ranges within the formulas on each sheet so that they encompass the data on your master log. Then you can just drag the formulas down (say something like 100 rows for each state sheet), and they will update automatically.

    Hope this helps!
    Attached Files Attached Files
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

+ 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. Automatically move rows of data to different worksheets based on cell criteria
    By Kaz09 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-08-2013, 12:49 PM
  2. How do I get data to automatically flow to another sheet? excel 20
    By dizzyjulie19 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 AM
  3. How do I get data to automatically flow to another sheet? excel 20
    By dizzyjulie19 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 AM
  4. How do I get data to automatically flow to another sheet? excel 20
    By dizzyjulie19 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  5. [SOLVED] How do I get data to automatically flow to another sheet? excel 20
    By dizzyjulie19 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 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