I am trying to create an order form using lookup tables. With Customer information coming from one worksheet and "skus",pricing, qnty blah, blah..coming from another worksheet. Is there a way I can access these other worksheets without actually having them open?
I am not a VBA person and have tried to do this with formulas, here's what the formula looks like:
=LOOKUP($A14,'C:\Documents and Settings\Mark B\My Documents\[sku2.xls]Sheet1'!$A$2:$A$28000,'C:\Documents and Settings\Mark B\My Documents\[sku2.xls]Sheet1'!D$2:D$28000)
I have also tried to attach a copy of the order form.
Any suggestions would be most helpful.