get next available

[KS75f]

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.

[shg]

Maybe

=max(someRange)+1

[KS75f]

No that didnt work.

i need it to be like "look up table 1, look for next blank in column index 6, then lookup the corresponding number in column 1 and past that number in f4"

Please Login or Register  to view this content.

that was the macro i did but it always brought back the copy from C7 instead of the next blank one because this sort by blanks just hides the rows....

[KS75f]

i figured one way out..

created a pivot table with a slicer and ran the macro to refresh the pivot table to get the next with the cell needing to be updated equaling the top option in the pivot table.