Hey all, I will get right to my question.
I am trying to make a macro for a spreadsheet I've been asked to look at. There are 2 sheets that I'm focusing on this spreadsheet which are named Search & Update and Master.
Master has a table named Table 1, which starts in column A to column Q. It's the only information on that sheet.
What I have now is on the 1st sheet Search & Update, in cell B3 I have it where you enter a Job # and below in cells A6:R6, the info about the job are populated using a Index formula that pulls from Table 1. In those cells it makes it so you can update information about the job.
After updating the information I need a macro to search for the value from cell B3 on Search & Update sheet off the Master sheet's Table 1 and update the information that was changed. All information that is updated would be on the row to the right of the job # which the job # is in column F of the table.
Another condition is if they update the job on Search & Update from the drop down list in cell M6 and select Complete, that job needs to be deleted from Table 1 when they run the update macro(which would be the whole row).
As an side note this spreadsheet has a user form from which adds new jobs to Table 1. If possible it would be great to add what I'm doing to the user form, where they could search for a Job # and the ability to and update.
I am still fairly new to VBA and don't get that much time to mess around with it. I have macros built in for other functions but this has made me hit a road block... to the point I'm posting this off mobile hoping to get help.
Any help would be greatly appreciated.
I am trying to make a macro for a spreadsheet I've been asked to look at. There are 2 sheets that I'm focusing on this spreadsheet which are named Search & Update and Master.
Master has a table named Table 1, which starts in column A to column Q. It's the only information on that sheet.
What I have now is on the 1st sheet Search & Update, in cell B3 I have it where you enter a Job # and below in cells A6:R6, the info about the job are populated using a Index formula that pulls from Table 1. In those cells it makes it so you can update information about the job.
After updating the information I need a macro to search for the value from cell B3 on Search & Update sheet off the Master sheet's Table 1 and update the information that was changed. All information that is updated would be on the row to the right of the job # which the job # is in column F of the table.
Another condition is if they update the job on Search & Update from the drop down list in cell M6 and select Complete, that job needs to be deleted from Table 1 when they run the update macro(which would be the whole row).
As an side note this spreadsheet has a user form from which adds new jobs to Table 1. If possible it would be great to add what I'm doing to the user form, where they could search for a Job # and the ability to and update.
I am still fairly new to VBA and don't get that much time to mess around with it. I have macros built in for other functions but this has made me hit a road block... to the point I'm posting this off mobile hoping to get help.
Any help would be greatly appreciated.