+ Reply to Thread
Results 1 to 11 of 11

Extract information from data

Hybrid View

  1. #1
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    3,178

    Re: Extract information from data

    I wonder if you'd be able to present this list in a table and structure it so the weeks go down the page. I've attached an example of what I'm thinking. To get what you want, you just need to filter the Issue column so it doesn't show blanks. This allows you to sort and filter to get any information you may want.
    I've assumed that some columns are the same depending on the store name (that may be incorrect, but may give you options).
    I moved the Store column to the right so as you enter new records, you just need to type in the Store name, and everything else to the left fills in automatically. Some of that may need to be changed depending on how you get those values.
    Would this work for you?
    Attached Files Attached Files
    Last edited by Gregb11; 07-14-2019 at 04:51 PM. Reason: attachment didn't upload

+ 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. Replies: 5
    Last Post: 06-26-2016, 12:52 AM
  2. [SOLVED] Extract Invoice Information from Source Data Sheet to Individual Worksheets
    By HangMan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-31-2015, 11:37 AM
  3. Replies: 2
    Last Post: 11-27-2013, 12:48 AM
  4. Information Extract
    By mfjanoo in forum Excel General
    Replies: 5
    Last Post: 04-10-2013, 04:47 AM
  5. How to extract Information from an Excel File and entering those data in a text file?
    By bikash.nitk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-10-2012, 12:13 PM
  6. Replies: 2
    Last Post: 10-23-2008, 11:19 AM
  7. extract relevent data information in other cells
    By stevekirk in forum Excel General
    Replies: 4
    Last Post: 09-12-2006, 11:22 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