Update an Excel table with new values from another table

by

Assuming your table B is in sheet2 and table A is in sheet1 then

Sub test()
    Sheets("Sheet2").Range("TableB").Copy
    Sheets("Sheet1").Range("TableA").PasteSpecial Paste:=xlPasteValues, _
                                                  Operation:=xlNone, SkipBlanks:=True, Transpose:=False
End Sub

More Related Contents:

  1. How do I reference tables in Excel using VBA?
  2. Format Cell Contents
  3. Excel formula checklist in employees
  4. How do I put double quotes in a string in vba?
  5. Excel VBA – How to add dynamic array formula
  6. How can I URL encode a string in Excel VBA?
  7. Row count on the Filtered data
  8. VBA – Write all possible combinations of 4 columns of data [duplicate]
  9. Remove duplicates from array using VBA
  10. 2 ways for “ClearContents” on VBA Excel, but 1 work fine. Why? [duplicate]
  11. How to automatically insert a blank row after a group of data
  12. Get File Path (ends with folder)
  13. Email a single attachment from folder of files each to a different person
  14. Bad data selection using VBScript , on date field values
  15. Excel error 1004 “Unable to get …. property of WorksheetFunction class” appearing inconsistently
  16. Sending object array to variant works before August 2019 Windows update, but fails after update
  17. Find last row in range
  18. How can I install/use “Scripting.FileSystemObject” in Excel 2010 for MAC?
  19. Differences between Excel’s Form Controls & ActiveX Controls
  20. Excel VBA User Defined Function that counts cells with conditional formatting
  21. How to add an attachment to an email using VBA in Excel
  22. Get Timezone Information in VBA (Excel)
  23. Excel is calculating a formula with a VBA function as an error unless it is re-entered
  24. Excel VBA Run-time error ’13’ Type mismatch
  25. ThisWorkbook.FullName returns a URL after syncing with OneDrive. I want the file path on disk
  26. SAP Extract into EXCEL via VBA out of memory
  27. How to query a MS-Access Table from MS-Excel (2010) using VBA
  28. How to roundup a number to the closest ten?
  29. Convert month name into number
  30. Display a message box with a timeout value

Leave a Comment