Macro to Update Data on Table From Seperate Sheet

Tryry

New Member
Joined
Dec 8, 2014
Messages
2
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.
 

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top