Hello All,
I'm looking for a macro that will open a separate workbook, find a specific cell value, and then insert a blank row under it.
Here are the steps the user will take.
1. Open data entry excel file.
2. Enter the job number in cell D5.
3. Click ActiveX Command Button "Add Row".
At the point, the macro should open a separate excel file called "JobBook," find the job number in column B of the JobBook, and then insert an entire blank row below it.
I've seen code to insert rows, but only for the current workbook. I want it to open a separate workbook and insert the row there.
Thanks!
I'm looking for a macro that will open a separate workbook, find a specific cell value, and then insert a blank row under it.
Here are the steps the user will take.
1. Open data entry excel file.
2. Enter the job number in cell D5.
3. Click ActiveX Command Button "Add Row".
At the point, the macro should open a separate excel file called "JobBook," find the job number in column B of the JobBook, and then insert an entire blank row below it.
I've seen code to insert rows, but only for the current workbook. I want it to open a separate workbook and insert the row there.
Thanks!