excel table

  1. O

    Add multi-row range at the end of a Table(Listobject)

    Hello I have some data in a worksheet in columns A through E...The rows of data are changing..Some day the range may be A5:E10, another day A5:E30..These data are not in a table (listobject).I am trying to paste them in a table (listobject) in another workbook.I have managed to paste them...
  2. F

    VBA: Excel data into Word Templae

    Hi, very new to VBA How in excel with VBA can i transfer information from an Excel sheet to create a unique Word document using a template. For example, i have a list of New Hires and their information in an Excel sheet. I need their unique information in a word template in specific places
  3. S

    How to convert table from one form to other form?

    Hello Fellow Experts, I have a table in the form of "INPUT" format. I want to convert that table in the form of "OUTPUT" format. What is the best way to do that? Here is the link to the source file and also attached image There is a Previous thread. Peter has solved a similar problem quite...
  4. K

    # HOW TO MATCH "HSN CODE" AFTER PULL DATA ON DIFFRENT-DIFFRENT TABLE ???

    # HOW TO MATCH "HSN CODE" AFTER PULL DATA ON DIFFERENT-DIFFERENT TABLES ??? We need pull data into different- different Table . Kindly Help on solve my Query, Kindly Send us Proper formula , - perfect match " HSN CODE" And pull data from TABLE1 , send to matching table
  5. D

    Table summary issue (VBA or formula)

    Hi all, I am struggling to find a smart and efficient way where I can make a list out of a huge table. Thought there would be someone here that could help me find a way to build a macro or some condition formula in order to obtain the result i am after. Its heavy manual work but somehow i want...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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.
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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