+ Reply to Thread
Results 1 to 1 of 1

Retrieve Data from one sheet to another

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    12-21-2004
    Location
    MN
    MS-Off Ver
    Microsoft 365
    Posts
    213

    Retrieve Data from one sheet to another

    I have data on one sheet with some of the following columns
    Workorder ~ Date ~ Description ~ Quantity ~ Amount ~ G/L Account
    NU-702-06 ~ 6/6/06 ~ Menards ~ 0 ~ $150.00 ~ 2232

    Then I have 100+ tabs for each workorder. Each tab contains a form that has information on it regarding the invoices that pertain to that workorder.
    What I would like to do, is enter all the invoices on that first sheet and have each tab automatically update. So for instance, in the example above, I would like to have that same information show up on the form for tab 702.

    Does that make sense? Currently I have the first sheet show all the invoices and then I copy and paste each one into the individual workorder sheets. I am sure there is a better way to do this, I just can't seem to figure it out. Thank you for your help in advance!
    Last edited by karstens; 07-11-2006 at 04:25 PM. Reason: Change Notification

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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