I have 2 sheets for job scheduling. The first sheet is a calendar that has the days sorted vertically, with 8 columns for different jobs that can occur in the same week. The second page is all of the scheduled jobs listed horizontally where you can assign teams. The calendar sheet has hyperlinks to the corresponding job on the team entry sheet.
I have a macro that can either delete a job or change the dates of an existing job. When the job is deleted, it is removed both from the calendar and the teams sheet. For the teams sheet, the macro just deletes the column for that job so that everything else is more easily slid over to the now vacated column. This is where the issue lies. Once that column is deleted, the hyperlinks on the calendar sheet still go to their associated columns, but the job that is there now is the wrong one since everything shifted except for the hyperlink address.
Is there an easy way to update every hyperlink after a job is deleted, or is there an easier way to ensure the hyperlink always goes to the correct job? This spreadsheet is on a government computer, and I am posting this from my phone, so if you need code or anything the best I can do is take a picture of my monitor. Thanks in advance!
I have a macro that can either delete a job or change the dates of an existing job. When the job is deleted, it is removed both from the calendar and the teams sheet. For the teams sheet, the macro just deletes the column for that job so that everything else is more easily slid over to the now vacated column. This is where the issue lies. Once that column is deleted, the hyperlinks on the calendar sheet still go to their associated columns, but the job that is there now is the wrong one since everything shifted except for the hyperlink address.
Is there an easy way to update every hyperlink after a job is deleted, or is there an easier way to ensure the hyperlink always goes to the correct job? This spreadsheet is on a government computer, and I am posting this from my phone, so if you need code or anything the best I can do is take a picture of my monitor. Thanks in advance!