tables - Search Results - Excel Help Forum

VBA & Tables

Started by Xlnovice1‎, 10-07-2020 07:28 PM

3

469

Last Post By:: Last Post: 10-08-2020 12:14 PM; by Richard Buttrey

Forum:
Excel Programming / VBA / Macros

Changing name of auto numbered headers in table

Started by DaBestEva‎, 09-28-2020 08:51 AM

3

436

Last Post By:: Last Post: 09-28-2020 09:37 AM; by torachan

Forum:
Excel General

[SOLVED] .csv Import. Resize table to match data set

Started by mattydboom1‎, 09-11-2020 05:30 PM

7

640

Last Post By:: Last Post: 09-13-2020 10:04 PM; by ikboy

Forum:
Excel Programming / VBA / Macros

[SOLVED] I'm stuck trying to pivot a column and cross reference two tables!

Started by tommo385‎, 08-29-2020 12:08 PM

9

1,945

Last Post By:: Last Post: 09-07-2020 07:56 PM; by tommo385

Forum:
Excel General

Project Time sheet

Started by hEINSTEIN‎, 08-10-2020 12:54 PM

7

1,741

Last Post By:: Last Post: 08-11-2020 03:44 PM; by FDibbins

Forum:
Excel General

Is there a way to change the AutoFill formula for a range?

Started by coupland‎, 06-26-2020 02:00 PM

2

1,082

Last Post By:: Last Post: 06-27-2020 01:00 PM; by AliGW

Forum:
Excel General

Combining data from two similar tables into one PivotChart

Started by tomolias‎, 05-27-2020 06:27 AM

2016 excel, pivot chart, relationship, tables

1

598

Last Post By:: Last Post: 05-27-2020 06:39 AM; by alansidman

Forum:
Excel Charting & Pivots

Calculating Days in Individual Months between Arrival Date and Departure Date - Table

Started by Danimal6‎, 05-06-2020 10:38 AM

3

539

Last Post By:: Last Post: 05-06-2020 12:29 PM; by DavidBowman

Forum:
Excel Formulas & Functions

XLOOKUP obtaining a value from another table that has an apostrophe prefix in the cell

Started by ozGreg‎, 03-22-2020 05:46 PM

formating, matching, tables, values, xlookup

2

862

Last Post By:: Last Post: 03-22-2020 09:05 PM; by ozGreg

Forum:
Excel Formulas & Functions

Pivot Table not being created by VBA Code

Started by paydog23‎, 03-20-2020 07:56 PM

1

439

Last Post By:: Last Post: 03-20-2020 08:15 PM; by alansidman

Forum:
Excel Programming / VBA / Macros

Taking a horizontal list with multiple values and converting it into a vertical list

Started by mcfurlong1‎, 03-19-2020 02:20 PM

columns, horizontal, lists, tables, vertical

1

862

Last Post By:: Last Post: 03-23-2020 10:45 AM; by JeteMc

Forum:
Excel Formulas & Functions

Dynamic Tables Based On Dropdown

Started by polishfc‎, 03-11-2020 10:54 AM

1

845

Last Post By:: Last Post: 03-11-2020 11:08 AM; by maclearyj

Forum:
Excel General

Weird interaction between tables across multiple worksheets.

Started by gibus‎, 03-08-2020 09:27 PM

4

1,071

Last Post By:: Last Post: 03-17-2020 11:23 PM; by gibus

Forum:
Excel General

multi-table or multi selection pivot for budgeting

Started by cudaboy_71‎, 03-01-2020 08:46 PM

3

549

Last Post By:: Last Post: 03-02-2020 01:24 PM; by cudaboy_71

Forum:
Excel Charting & Pivots

Array formula working in one workbook but not another

Started by vwhite‎, 02-26-2020 09:19 AM

array formula error, circular reference error, formulas, tables, workbooks

1

513

Last Post By:: Last Post: 02-26-2020 09:21 AM; by AliGW

Forum:
Excel Formulas & Functions

Format all worksheets in workbook as a table

Started by 7684010035‎, 02-06-2020 01:07 PM

20

1,423

Last Post By:: Last Post: 06-08-2020 08:48 AM; by 7684010035

Forum:
Excel Programming / VBA / Macros

Selecting which data to input

Started by Jfarnish‎, 01-28-2020 09:23 AM

1

389

Last Post By:: Last Post: 01-28-2020 09:29 AM; by Jfarnish

Forum:
Excel Formulas & Functions

INDIRECT function in Dynamic Data Validation does not work

Started by RJK‎, 11-22-2019 11:09 PM

data validation, dependant lists, offset function, tables

17

1,955

Last Post By:: Last Post: 11-28-2019 03:03 PM; by Bo_Ry

Forum:
Excel Formulas & Functions

[SOLVED] Set Range via Structured Reference get error on first vba run, but not second run

Started by truk2‎, 11-19-2019 10:20 PM

5

515

Last Post By:: Last Post: 11-20-2019 01:24 AM; by truk2

Forum:
Excel Programming / VBA / Macros

Copy data between two tables

Started by francorp‎, 11-07-2019 04:39 PM

2

305

Last Post By:: Last Post: 11-07-2019 05:24 PM; by Marc L

Forum:
Excel Programming / VBA / Macros

INDEX MATCH with 2nd MATCH lookup_value is in column

Started by rkong‎, 09-10-2019 10:52 PM

1

398

Last Post By:: Last Post: 09-10-2019 11:47 PM; by rkong

Forum:
Excel Formulas & Functions

Create A Dynamic Linked Table That Will Add Row(s) When A Row Is Added To The Parent Table

Started by Baltimorejack68‎, 09-03-2019 09:00 PM

0

372

Last Post By:: Last Post: 09-03-2019 09:00 PM; by Baltimorejack68

Forum:
Excel Programming / VBA / Macros

Create A Dynamic Linked Table That Will Add Row(s) When A Row Is Added To The Parent Tab

Started by Baltimorejack68‎, 09-03-2019 04:27 PM

1

436

Last Post By:: Last Post: 09-04-2019 01:48 AM; by Pepe Le Mokko

Forum:
Excel General

Filtered Tables - Average and Sum

Started by SimonCampbell‎, 08-26-2019 08:38 AM

2

440

Last Post By:: Last Post: 08-26-2019 09:59 AM; by Pepe Le Mokko

Forum:
Excel Formulas & Functions

Conditionally Format According to Food Groups & sort the rows to be grouped in colour/food

Started by gabriellewills‎, 08-23-2019 02:08 AM

conditional fomatting, formatted cells, tables, vba

5

504

Last Post By:: Last Post: 08-23-2019 03:14 AM; by AliGW

Forum:
Excel Formulas & Functions

Lock Table But Allow Sorting

Started by SKKS‎, 07-15-2019 04:26 PM

5

1,738

Last Post By:: Last Post: 07-15-2019 04:52 PM; by SKKS

Forum:
Excel General

Complex table transformation - Insert rows between 2000 rows and move column data to row d

Started by justayellowbusman2‎, 06-25-2019 02:16 PM

2

641

Last Post By:: Last Post: 06-28-2019 09:19 PM; by JeteMc

Forum:
Excel Programming / VBA / Macros

Auto populate a cell from a drop down menu

Started by RichardLeagues4You‎, 06-20-2019 04:41 AM

3

389

Last Post By:: Last Post: 06-20-2019 05:17 AM; by KOKOSEK

Forum:
Excel Programming / VBA / Macros

[SOLVED] Dependent combobox to show values from a table column

Started by UltimateNeo‎, 06-19-2019 11:32 PM

4

428

Last Post By:: Last Post: 06-20-2019 12:54 AM; by UltimateNeo

Forum:
Excel Programming / VBA / Macros

[SOLVED] continuing formulas down tables automatically, not working for me

Started by jitterbug888‎, 06-19-2019 08:43 AM

14

1,648

Last Post By:: Last Post: 06-24-2019 08:41 AM; by JeteMc

Forum:
Excel Formulas & Functions

Assign column values to heading?

Started by Cranners‎, 06-13-2019 12:51 AM

10

520

Last Post By:: Last Post: 06-13-2019 07:05 AM; by AliGW

Forum:
Excel Formulas & Functions

[SOLVED] Remove Table Properties from Workbook

Started by sstreub‎, 05-12-2019 11:36 AM

file size too large, slow response, tables

9

748

Last Post By:: Last Post: 05-14-2019 12:12 PM; by sstreub

Forum:
Excel General

Best way to OUTPUT/COPY selected rows and all columns from a dynamic table

Started by LarVan‎, 05-06-2019 02:41 PM

extract rows, pivot table, query, tables

3

2,459

Last Post By:: Last Post: 05-14-2019 12:15 AM; by JeteMc

Forum:
Excel General

Data Entry Form Inserting New Row Outside of Table

Started by Niccii‎, 04-24-2019 02:47 PM

data entry form, macro, new row macro, tables

5

455

Last Post By:: Last Post: 04-26-2019 10:43 AM; by sintek

Forum:
Excel Programming / VBA / Macros

Slice multi-column ranked relational pivot

Started by correa.cristobal‎, 04-22-2019 03:27 PM

2

568

Last Post By:: Last Post: 04-22-2019 03:54 PM; by correa.cristobal

Forum:
Excel Charting & Pivots

Search:

Search: Replies Views Search took 0.01 seconds; generated 26 minute(s) ago.

VBA & Tables

Changing name of auto numbered headers in table

[SOLVED] .csv Import. Resize table to match data set

[SOLVED] I'm stuck trying to pivot a column and cross reference two tables!

Project Time sheet

Is there a way to change the AutoFill formula for a range?

Combining data from two similar tables into one PivotChart

Calculating Days in Individual Months between Arrival Date and Departure Date - Table

XLOOKUP obtaining a value from another table that has an apostrophe prefix in the cell

Pivot Table not being created by VBA Code

Taking a horizontal list with multiple values and converting it into a vertical list

Dynamic Tables Based On Dropdown

Weird interaction between tables across multiple worksheets.

multi-table or multi selection pivot for budgeting

Array formula working in one workbook but not another

Format all worksheets in workbook as a table

Selecting which data to input

INDIRECT function in Dynamic Data Validation does not work

[SOLVED] Set Range via Structured Reference get error on first vba run, but not second run

Copy data between two tables

INDEX MATCH with 2nd MATCH lookup_value is in column

Create A Dynamic Linked Table That Will Add Row(s) When A Row Is Added To The Parent Table

Create A Dynamic Linked Table That Will Add Row(s) When A Row Is Added To The Parent Tab

Filtered Tables - Average and Sum

Conditionally Format According to Food Groups & sort the rows to be grouped in colour/food

Lock Table But Allow Sorting

Complex table transformation - Insert rows between 2000 rows and move column data to row d

Auto populate a cell from a drop down menu

[SOLVED] Dependent combobox to show values from a table column

[SOLVED] continuing formulas down tables automatically, not working for me

Assign column values to heading?

[SOLVED] Remove Table Properties from Workbook

Best way to OUTPUT/COPY selected rows and all columns from a dynamic table

Data Entry Form Inserting New Row Outside of Table

Slice multi-column ranked relational pivot