Move Data from One Table to Another Automatically

[Mohammedismail]

Hi,

I have a Macro Which my team members fill and submit the information of their daily workload. And the person who Submits has a Pivot table to check if the Workload that he has submitted has been QCed or not.

I have made 2 Tables one is temporary database and other is a master Database, I keep clearing the Temp Database because when users refresh the Pivot table it takes less time if there is less data and Vice Versa.

Problem Statement: When a particular Column is updated for example "QC Result" column is updated as "Green" or "Red" the entire column needs to be moved to the Master Table.

Any Help is appreciated.

PS: I'm currently doing it through Insert Into and I want to avoid doing that Manually.

 

[JHB]

Use an Update query, which is run in after update event for the control.
Or if you want to insert the whole row/record, then an Append query in the same after update event.
Use an If statement to determine if the Update/Append query has to to be run.