Results 1 to 5 of 5

Transfer Data to separate tables based two variables (site and product)

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-28-2009
    Location
    Portland, Maine
    MS-Off Ver
    Excel 2003
    Posts
    102

    Transfer Data to separate tables based two variables (site and product)

    - I have a data entry tab for tracking unit volume and cost of products needed for each site

    - I need to transfer the five columns of data (UNIT COST, UNITS, LABOR COST, LABOR HOURS, TOTAL COST) to individual tables (UnitCost_TBL, UnitsTotal_TBL, LaborCost_TBL, LaborHRs_TBL, Total_TBL)

    - I need to mach on the PRACTICE and PRODUCT (both named ranges on data entry tab)

    - I've tried to modify to other programs that do a similar thing but they are both too complicated for me at this point.

    - Spreadsheet is attached.

    - Any help is greatly appreciated as always.

    Thanks!
    Attached Files Attached Files
    Last edited by yunesm; 04-15-2010 at 09:47 PM.

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