Hi There,

I dont know if there is a formula for this but Im still super new to excel macros and formulas so I figured i would hop in and ask.

I am looking to have a cell pull the next available # from a table. so we have a list of purchase order numbers we are using and when one is used we fill in the basic information i.e. company, placed by, etc. i want the cell to check the table and pull the next unused po. Is there a way to o this? the table and the cell are in two different spreadsheets.