Does anyone know of a way to have the excel find function work within a macro.
I have got an invoice tabs and a few different revenue tabs. I plan on assigning each revenue tab a seperate set of shortcut keys.
When ran, I am wanting it to lookup a value in the newly added item to the invoice tab, and insert a row below the last occurance (could be first if easier) of that value in the revenue spreadsheet.
For a better explanation, if ran it will pick up the customer name in the invoice tab, and look up the corresponding value in the revenue tab (assigned a unique shortcut key), then insert a blank row below the last occurance. Is this possible? <!-- / message -->
I have got an invoice tabs and a few different revenue tabs. I plan on assigning each revenue tab a seperate set of shortcut keys.
When ran, I am wanting it to lookup a value in the newly added item to the invoice tab, and insert a row below the last occurance (could be first if easier) of that value in the revenue spreadsheet.
For a better explanation, if ran it will pick up the customer name in the invoice tab, and look up the corresponding value in the revenue tab (assigned a unique shortcut key), then insert a blank row below the last occurance. Is this possible? <!-- / message -->
