+ Reply to Thread
Results 1 to 2 of 2

Extract/present data from master sheet

  1. #1
    Registered User
    Join Date
    05-24-2016
    Location
    Manchester, England
    MS-Off Ver
    2010
    Posts
    1

    Extract/present data from master sheet

    Hi

    I've just started a new job - we have a monthly process, which I'm hoping can be streamlined:

    A master data sheet is produced each month from which data per external provider is filtered and then exported as A PDF and sent via e-mail as an attachment to that provider.

    The master spreadsheet can't be sent to all as it contains commercially sensitive info. Just considering any options that might quicken this process?

    There are around 40 different providers that need to see their individual extract of data. Any thoughts?

    Thanks

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,420

    Re: Extract/present data from master sheet

    Would be a lot easier to help if a sample of the master data sheet and template for the sheet to be exported was included. To attach a sample workbook. Make sure there is just enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    That said here is an example of how you could use the following array formula* to segregate data by provider:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    * Confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
    Let me know if you have any questions
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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: 1
    Last Post: 09-15-2014, 01:03 PM
  2. Replies: 3
    Last Post: 05-07-2014, 11:05 AM
  3. extract rows from master sheet into separate sheets
    By nikki3973 in forum Excel General
    Replies: 2
    Last Post: 07-26-2013, 12:55 PM
  4. Replies: 4
    Last Post: 03-05-2013, 01:02 PM
  5. Extract data into master work sheet
    By kammariarun in forum Excel General
    Replies: 0
    Last Post: 12-11-2011, 03:53 PM
  6. Extract info from tab sheets to master sheet
    By sonyamartinez1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2011, 04:22 PM
  7. How to extract data if a value is present
    By monkdelafunk in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 08-28-2008, 02:13 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