Results 1 to 3 of 3

Extract Invoice Information from Source Data Sheet to Individual Worksheets

Threaded View

HangMan Extract Invoice Information... 10-30-2015, 04:03 PM
FDibbins Re: Extract Invoice... 10-30-2015, 06:03 PM
HangMan Re: Extract Invoice... 10-31-2015, 11:37 AM
  1. #1
    Forum Contributor
    Join Date
    06-21-2010
    Location
    -
    MS-Off Ver
    Excel 2010
    Posts
    1,211

    Extract Invoice Information from Source Data Sheet to Individual Worksheets

    I have a data Worksheet that holds invoice details based on a 'Code' in column A (see attached sample).

    Each code then has its own tab in the Workbook. I'm trying to find a way to extract the invoice information from the 'Data' tab that relates to each 'Code' so it appears on the associated tab based on the code entry in cell C3.

    I've completed the expected outcome for tabs AB123, AB124 and AB127 and provided the criteria on the Data tab. The idea being that when a 'Code' is entered in cell C3, it extracts the relevant date from the data tab as per the sample worksheets.

    I have no idea if this is possible to achieve using formula or code but would welcome any help trying to find a solution. Please let me know if anything doesn't make sense.

    Many thanks
    Attached Files Attached Files
    Thanks,
    HangMan

    You can say "Thank you!" by clicking Add Reputation below the post.
    Please, mark your thread [SOLVED] if you are happy with the solution.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 06-23-2014, 11:05 AM
  2. Extract data from worksheets to create a summary sheet
    By sniffer in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-28-2013, 07:17 PM
  3. [SOLVED] Consolidating multiple worksheets into one and retain links to source data in master sheet
    By enigmadreama in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-09-2012, 08:33 PM
  4. How to Automate data extract frm M'sheet into separate worksheets.
    By manz767 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2012, 09:20 AM
  5. Replies: 3
    Last Post: 01-10-2012, 06:58 PM
  6. Replies: 15
    Last Post: 08-13-2008, 10:37 AM
  7. Replies: 2
    Last Post: 03-12-2008, 02:38 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