+ Reply to Thread
Results 1 to 1 of 1

Pulling information from one main worksheet and moving certain information to multiple

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    Pulling information from one main worksheet and moving certain information to multiple

    I have attached a workbook for multiple things I would like to happen.

    The 1st spreadsheet is the main page. This is inputted manually. I list all truckloads of material which came in, where it came from, the date, freight cost, pounds of each grade of material and total pounds received. Average freight cost/pound is figured by dividing freight cost by total pounds. I will continue to add to this list of loads being received.

    The 2nd spreadsheet is the price of each grade of material from each plant. This can change over time as well as I've put an example in.

    The 3rd, 4th and 5th spreadsheet are each individual plants sheet. I need to take the information from the main sheet and move it to each individual page for where the material came from as well as getting a total cost of each grade of material so I need to pull the cost information from the Price of material page for each plant according to date received and multiply it by the pounds received.
    (These worksheets actually will need to go to separate workbooks because each plant has its own folder with multiple other documents relating to each plant - I just used spreadsheets for easier access.)

    The last spreadsheet has individual pallets of material listed with which load it came on, the pallet # given, the grade of material and pounds received. This is entered manually. The last column - I need it to read which Stock # it came on so it can find the Average freight cost of the stock # from the main page and also add this to the price of the material from the plant it came from including making sure the date of the price is correct.

    Any help or advice of setting all of this up in a different way would be greatly appreciated.
    Attached Files Attached Files

+ 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. Pulling information from 1 worksheet to another
    By jammerz24 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 04-14-2013, 09:54 PM
  2. Transfer information from main file to multiple sub files automatically
    By Beeboy1979 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-02-2012, 05:18 AM
  3. Main information row with sub row
    By swhitesell in forum Excel General
    Replies: 2
    Last Post: 10-29-2012, 12:36 PM
  4. [SOLVED] VBA to create multiple worksheets, rename, and insert information all off main sheet ...
    By headstrong2740 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-03-2012, 10:24 AM
  5. Pulling information to the main file from different files
    By shido in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-23-2011, 07:20 AM
  6. Pulling information into another Worksheet
    By colbyjack in forum Excel General
    Replies: 0
    Last Post: 01-18-2011, 11:50 AM
  7. Replies: 1
    Last Post: 08-11-2006, 05:45 AM
  8. [SOLVED] Pulling in Information from a worksheet
    By NEWB in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-05-2005, 12:50 PM


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