update table

  1. T

    Dynamically update table row categories from a source list

    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...
  2. M

    VBA Update table

    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...
  3. S

    VBA Code for exporting info from Excel to Access - Mostly Update field and some times append record

    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...
  4. D

    Update different sheets . VBA

    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...
  5. D

    Table Update Not Updating...

    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...
  6. Trevor G

    Edit field in Table VBA

    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...

This Week's Hot Topics

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
Top