If-then I think RRS feed

  • Question

  • I have two workbooks in an EXCEL file. On one workbook, I have a column with reference numbers 1.1 thru 1.10, 2.1 thru 2.10, through 8.1-8.10 to define certain catagories.  Each reference #, say 1.1, will have a 2nd column with a description (Cost of Goods) and a 3rd column with a dollar amount.  1.1 / Cost of Goods / $750. 

    I want to take the description and the dollar amount from 1.1 on the 1st woorkbook and place them in the column referenced by 1.1 on the on the other workbook.  So, if I reference 1.1 on workbook #1, Excel will place the description and dollar amount in the corresponding columns of 1.1 of the other workbook.  Is this stated clearly enough for help with an answer?
    • Moved by Mike Walsh FIN Thursday, September 17, 2009 6:26 AM off-topic (From:SharePoint - Excel Services)
    Wednesday, September 16, 2009 7:41 PM


All replies