+ Reply to Thread
Results 1 to 2 of 2

Linking several sheets to one master sheet

  1. #1
    Registered User
    Join Date
    09-17-2008
    Location
    Preston UK
    MS-Off Ver
    2003
    Posts
    9

    Linking several sheets to one master sheet

    Hi

    I complete a parts order sheet everyday which could contain several lines under the same order number. The line has the following data; Registration, Part number, Part description, Quantity, the date and order number are also on the sheet.

    What I need to do is link the lines with the date and order number to one master sheet that records all the data and when a new order is created all the lines are added to the master so eventually the master can show several orders then I can easily find out what has been received and whats on order.

    How can I do this?

    Many thanks

    Mick

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    There's an example called Contacts Form that might help here

    http://www.excel-it.com/vba_examples.htm
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ 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. Copy data from multiple sheets to single sheet
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 10-22-2010, 05:33 PM
  2. Excel VBA Help - Referencing across sheets
    By elmerg in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-06-2008, 11:24 AM
  3. getting data from one sheet to show up in other sheets
    By stacyreeves in forum Excel General
    Replies: 2
    Last Post: 06-23-2008, 12:00 PM
  4. Linking 6 Spread Sheets
    By ineedalotofhelp in forum Excel General
    Replies: 1
    Last Post: 02-10-2008, 05:01 AM
  5. Update worksheets automatically when Master Sheet is updated
    By ApothecaryFairy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-04-2008, 01:43 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