update table

I am trying to figure out if there is a way to update table row categories when a list on a different sheet is updated. For example, on Sheet 1 I have the source table like the following: <tbody> Categories Fruits Veggies Meat </tbody> Then I have the destination table on Sheet 2 that...

Hi Gurus, Looking for your help to fix my code below, what I am trying to do is to update my table vertically, instead of horizontally. Just to clarify, I was updating my data like this: <tbody> A B C D E F G 1 2018-30 2018-31 2018-32 2018-33 2018-34 2018-35 2 Open 27 26 25 27 28 30 3...

Dear all, I have an access database where i keep track of various tasks of a project and i need to give an excel sheet to few people where they can have rights to modify the status of the task from open to in progress to complete and also input the completion date. I would need a VBA macro to...

I'm new to all VBA concepts so I really need help. I have a file with 3 sheets. The first one contains clients from the UK and FR (this being column 3) , the second one clients only from the UK and the third one clients only from FR. I want a code that will update the second and third sheet once...

I want to create a new table in MS Access 2007, based on 2 other tables. Table A has all the data. However, where table A and table B have the same value (specifically field12), I want to replace that value with the number "2". I thought the criteria would be something like: =IIf([Numerics...

I am seeking to use a module sheet to create a sub/function to update a field if it meets certain criteria I have a table called = "GDV_Rates_Conventional_Sum" and I have a fields called "No_Of_Risks_Sum" What I need to do is fill a field if the following occurs number of No_Of_Risks_Sum is...