excel table

  1. J

    Highlight consecutive cells in a row and collunm from table

    Hello, I am trying to highlight the value "0" with conditional formating in consecutives cells (in the table) in the same row and in the same colunm like I done manualy in picture b3a. The first value in the table is in cell B3. I have this formula...
  2. MishTaylor

    VBA - Results Populating Outside Excel Table

    Hi Everyone, I need some help with my code to reference the table properly. Right now, when I run this code, the data populates outside of the table - not sure how to reference the table correctly. Table = "PrevReport" Sheet = "Print Reports" The data is being filtered by date range from...
  3. 5

    Speed up an Autofilter with 20k+ rows

    Hey everyone. Hope you're all doing well. I have a listObject table with 20k+ rows that I'm filtering with a textbox. This is the code I modified a little from extendoffice: Private Sub TextBox1_Change() 'Update by Extendoffice 2018/08/22 Dim xStr, xName As String Dim xWS As Worksheet Dim xRg...
  4. P

    Dynamic cell and sorting

    So here is the deal. I need that cell in E4 to be dynamic because the "Description" column on the Excel table is supposed to be sortable. By dynamic I mean that no matter the order of the Excel table, cell E4 should always report the correct tag associated to the description. How can I achieve...
  5. S

    Formula or VBA? Copy and paste Table rows.

    I have a sheet that has 4 tables. Let's say tables are A, B, C, and D. Table B has columns A-O, if column O has the value of W then copy that row (Column's A-N) and paste to the next available row of table D. Any help would be greatly appreciated.
  6. M

    How do I add conditional formatting for a row in my table if the value in Date column is not one day greater than one row above?

    I have a large Excel table with a Date column. The values in Date column range from 6/1/2003 to today. How do I add conditional formatting that will surround a table row with a huge red border (or a highlight in yellow) if the current value of Date is not exactly one day greater than the...
  7. E

    Prevent deletion of last row of excel table

    Hi folks I have an Excel Table with names and abbreviations of names (two columns only). I would like to prevent users from deleting the header row and last row in the table. <tbody> Abbreviation Surname and Initial PM Masters, P JL Leonard, J JM Matsau, J TOTAL 3 [given by...
  8. D

    Test ISBLANK on Excel Table Column

    Hi I am having a bit of a brain fart! I have the following formula =IF(MIN(AsBuiltWorkPaper[QTY])=0,"Error","OK") AsBuiltWorkPaper[QTY] is a column in an Excel table, and I am trying to amend the above formula with an OR to also return "Error" if any cell in the column is blank. I have...
  9. G

    Excel TABLE - VBA to move cell from one table to another

    New to VBA and trying to piece together a macro but the table part is causing me problems. I have multiple "3 or 4 column" tables on a worksheet. I want to move a cell value by Double Clicking the cell on one table, then click anywhere on another table to move that cell value to that table...
  10. M

    Excel table with information

    Hi all, Hope You can help me. I have a pretty big table and want some information out of it but don't know how to do it. Hope You guys (and girls) have some ideas. The idea of the table is: <tbody> A B C D E F G H I J Name 1 V V V V V V V V V V Name 2 V V Name 3 V V V V...
  11. D

    Copy-pasting into autoexpanding table inconsistent formulas

    Hi guys! Really ran out of ideas, so looking for some bright new ones. A relatively straightforward problem, however trying to give some background and hoping it not to become too cumbersome. I have an Excel 2016 xlsm worksheet with a table that has header and one empty row which would...
  12. M

    Create a unique sequencial record number when userform inserts record

    Hi Once again consulting the genius that is the MrExcel Community I am trying to find a way to create a unique sequential record number when my userform inserts a record in to a table. To be added when i run the below the code. Have just left column 1 of the table with the easy =Row() which...
  13. R

    Copy Excel Table Style from another file

    I have tried the following code to apply Table Style within the same Workbook, and it works fine: ActiveSheet.ListObjects(ActiveCell.ListObject.Name).TableStyle = "Table Style 1" However, when I am trying to apply the same style to a table in a different Workbook, it's not working. This is the...
  14. D

    Apply Multiple Conditional Formatting to a Table Column based on values in other columns

    Hi I am trying to add icons and colours to a table column based on values in adjacent columns. I am trying to do this with VBA as that seems the only way to do it. Basically In the table below, I want the column MilestoneA to be colored as per the column MilestoneA-RAG values and also contain...
  15. M

    Updating Formula in a Excel Table

    Hi Guys, I have an Excel table with some formula columns. In that columns, the value of some cells is calculated by formula and some rigid contents as text. I want to update the base formula for the new lines. For the current cells I am doing a is formula test and update them manually, but for...
  16. S

    Excel Table Auto Edit

    I have to edit a table containing my product items in such a way it only shows boundaries till the values i have entered . E.g I have set max no of rows i.e items as 10 for my invoice table and given them boundaries . Now it is not necessary that in every bill I have all the items ,for the...
  17. B

    Excel Table Auto Expanding Based Off Of Referenced Data

    I have an excel table that is built from data referenced data from other tables. i.e. sheet 1 table 1 =a1 =a2 sheet 2 table 2 bob jan if i add "stu" to the bottom of table 2 it expands but table 1 doesn't pic up the reference. Is there a way to automate that so i don't have to expand table 1...
  18. B

    External Data Dropping Cells with Alphanumeric Data

    Hello. I'm working with a workbook that connects to an external data source (table in excel) when opened. Most of the data from the external table consists of 6 numerical digits. However, some cells have alphanumeric cells which is the 6 digits followed by a single letter. The data connection...
  19. G

    Filtering Excel table based on conditional formatting in multiple columns

    I have an Excel table, where for a few different columns I have conditional formatting turning some cells to appear in bold red text. If I only did this on one column, I could then run a filter on the color, and it would eliminate the records that don't have that color-- but it only works on...
  20. S

    Limitations to Format As Table?

    I have an excel spreadsheet (Excel 2010) that has 3 columns, and approximately 59,900 rows. It's been sorted and duplicates (all 3 columns) removed. I would like to use the Microsoft Fuzzy Lookup tool to match one or more columns to one or more columns in another worksheet. The other...

Watch MrExcel Video

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