So I work in accounts payable,
we have hundreds of spreadsheets with different vendors, and we have multiple tabs based on fiscal year.
So my question is when I enter a Invoice number in say tab 1 but after that I have to retype it into another tab I know I can use =a1 but see I input many invoice numbers so the cell changes a1, a2 ,a3 Is it possible to make excel know that I want to input the last cell in a certain column?
if I wasn't clear please let me know ill try and explain better
we have hundreds of spreadsheets with different vendors, and we have multiple tabs based on fiscal year.
So my question is when I enter a Invoice number in say tab 1 but after that I have to retype it into another tab I know I can use =a1 but see I input many invoice numbers so the cell changes a1, a2 ,a3 Is it possible to make excel know that I want to input the last cell in a certain column?
if I wasn't clear please let me know ill try and explain better