I created a P.O. template which had an in-cell dropdown for Company Name using
Data Validation[list]. Upon selecting the company's name, it would then fill
in the corresponding address info for that company via VLOOKUP. The problem is
I now deal with many companies which have multiple locations. I've moved the
drop-down list to the right and added the appropriate fields so that it fills
in the correct information but I don't want the Company Code drop-down field to
actually print. I thought there was an easy way to suppress printing for a
specific cell [object] but I can't seem to find it. Print Area is set so all
the dropdown data off to the right does not appear.


----------------------------Printable Area-----------------------|
====================================|
Company Name [drop-down] | CoName Addr1 Addr2
Address 1................................................. .........|
Address 2................................................. .........|
====================================|
Company Name Company Code [drop-down] | CoCode CoName Addr1 Addr2
Address 1................................................. .........|

Address 2................................................. .........|

====================================|

Thank you