My Excel Workbook has two tabs. Tab 1 contains all project information such as project number, customer name, project name, contract amount and....... Tab 2 is to keep track of change order. I don't like to re-type the project number, project name, customer name and contract amount to tab 2 when I enter a change order number for a contract that is already in tab 1.
Is any way macro that will allow tab 1 's information to be copy to tab 2 when I enter the contract number to tab 2?
Thank you so much.
Macro that will allow tab 1 's information to be copy to tab 2