I have a workbook that contains several tabs for different revenue streams, and an Invoice tab that data is housed in for the rest of the workbook.
The revenue tabs are further broken down by customer, with each seperate invoice listed out with Customer in Column A, Invoice date in column B. See ex.
Bank of America mm/dd/yy
Bank of America mm/dd/yy
Citibank mm/dd/yy
Citibank mm/dd/yy
What I am wanting is a macro (a simple one for each seperate revenue tab) to perform a lookup of the last value entered into the invoice tab, and insert a blank row below the last occurance of the lookup value in one of the revenue tabs. I have 5 tabs and plan on assigning a different shortcut key to each.
I do not need it to place any data, text, etc. into the row, just insert a blank row for a placeholder.
The revenue tabs are further broken down by customer, with each seperate invoice listed out with Customer in Column A, Invoice date in column B. See ex.
Bank of America mm/dd/yy
Bank of America mm/dd/yy
Citibank mm/dd/yy
Citibank mm/dd/yy
What I am wanting is a macro (a simple one for each seperate revenue tab) to perform a lookup of the last value entered into the invoice tab, and insert a blank row below the last occurance of the lookup value in one of the revenue tabs. I have 5 tabs and plan on assigning a different shortcut key to each.
I do not need it to place any data, text, etc. into the row, just insert a blank row for a placeholder.
