excel table

  1. S

    Add Column to Excel Table (VBA) but only 1st row populates not entire row

    I have an Excel spreadsheet with Macros/VBA: * runs several SQL queries from an external database * populates worksheet(s) with SQL result(s) * in each worksheet, select data & create a table * add extra columns to most of these tables * add calculated formulas to first row of these extra...
  2. I

    Vlookup, Indirect, Excel 2007 Table, Different Worksheets

    I've got a workbook with tables on multiple worksheets. The worksheets are called Summary, Q1, Q2, Q3, and Q4. Each of the worksheets have tables: <TABLE style="BORDER-BOTTOM: #a3a3a3 1pt solid; BORDER-LEFT: #a3a3a3 1pt solid; BORDER-COLLAPSE: collapse; DIRECTION: ltr; BORDER-TOP: #a3a3a3...
  3. L

    ADO INSERT INTO with Excel table

    Hi, I'm writing some code to use ADO to pull some data from access. Everything works fine but I want the data to be placed in an existing table and using CopyFromRecordset seems to wipe the table. I can use an ODBC query, change the command and refresh but I'm trying to learn more about ADO at...

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