jcornish82
New Member
- Joined
- Jan 29, 2016
- Messages
- 1
Hello Everyone!
I need some assistance figuring out a problem on a job tracker I am creating. I have two workbooks, one which holds the data for each job with each newly created job being on its own row. The other workbook updates off of the original workbook and is where the manage can move jobs to production or delete the job off the schedule. I have created a macro button so the manager can push that and delete the entire row in their workbook.
I would like to know how I can code it so when the manager clicks that delete button it can open up the external workbook and delete whichever row has the same job number and add in a new blank row at say row 100.
I need some assistance figuring out a problem on a job tracker I am creating. I have two workbooks, one which holds the data for each job with each newly created job being on its own row. The other workbook updates off of the original workbook and is where the manage can move jobs to production or delete the job off the schedule. I have created a macro button so the manager can push that and delete the entire row in their workbook.
I would like to know how I can code it so when the manager clicks that delete button it can open up the external workbook and delete whichever row has the same job number and add in a new blank row at say row 100.
