tables

I have next table (growing each day). In each date/time moment (row), I have some event which may be repeated within one day (or not). Problem is ID column: I am entering IDs values manually and making mistakes of course. How to make some kind of automation: a) within one day (date), b) within...

I'm new to VBA Excel programming. I have a table with several headers and I would want to get absolute column number of some header. To be more clear. There is a form to which user should enter header name (practically header cell content) and the program should get absolute column number where...

Hello, I'm working with a table with many slicers. I want a command button that will clear all the filters from the slicers, but keep the 'year' slicer as is. Any help would be appreciated. I'm quite new with VBA, so please make it really obvious what parts of the code I should be substituting...

Hi, I have A:E columns. Column C and Column E are the ones who does have formulas and should be the protected columns. I would like to allow the user to copy and paste (aside from manually typing the inputs) any data into new rows and tables should still auto expand including the formulas. In...

Hello I need help setting up a weekly report table or pivot that shows the number of open, resolved, pending, and new added tickets. The new data for the report comes out every Monday morning and I will send my report every Monday afternoon showing the number of open, resolved, pending, and new...

Hi all, Using Excel Microsoft 365. I have an Excel Table. I deleted all data from the Table and then resized the table to $A$1:$A$2 I then added 13k rows of data beginning at Row 2. That is where the slowness began. Why does it take so long for Excel to resize the table to include all 13K...

Hi everyone, I am working on a program that has kind of a lot going on. I have a sheet that I manually input data into cells then use a macro to add that data into a "database" table in a separate sheet. that table has roughly 25 columns in it. from the initial macro only about half are...

Hi, I have a workbook with a macro that extracts information from row 1 and pastes it as values as a new row below the Data table. I want to add a step to extend the table over the new row, but none of the options I have found so far seem to do it. My VBA knowledge is negligible (I'm usually...

Hello, I have a search sheet to loop through my entire workbook and return results into a table-style format. for some reason it is producing 500 rows, but I only want it to produce enough rows for the data that is returned. I will paste the code below, and color the font of where the problem...

Hello again, I have a Table of Contents sheet that will change size on a constant basis. The VBA is written to format it into a table, for ease of filtering the data. I'm wondering if there is a way to add the values of a single column (specifically column "D") and have it show the total at the...

i am creating a document for work to help things flow faster and easier. This is a shipment plan, it is mainly done but its just the last part which im struggling with and hoping someone will have an answer. I am trying to summarise 1 sheet with 2 tables (for printing purpose) on another sheet...

When I run a macro that refreshes a Power Query table that is itself the combination of four (4) other tables, whose data is imported from external sources, then the action does not complete, and I receive the following when I select to debug: “Selection.ListObject.QueryTable.Refresh...

Hello, I'm struggling with a combined table result issue as follows and I'm hoping someone can help. I've got 5 seperate sheets, all with named tables that are exactly the same format - the tables refer to customer orders that contain the same data - so order live/dead, order number, part...

Good day to everyone on mrexcel i hope you can all help me with a complex issues I have.. I'm trying to create a dashboard, for our CCG and GP. So that they can select which CCG and if they want data on the CCG or GP or both. Via the use of 2 slicers. These slicers then have to filters...

My goal is to copy-paste formulas from tableSource (a ListObject) to tableDest (also a ListObject) and to have those pasted formulas refer to tableDest, not to tableSource, which is what I get when I do a little something like this: ListObjSource.ListRows(1).Range.Copy...

HI All, So ive a query that runs //runqry bring back data //refresh existing activeworkbook.connection (which always uses the same table name "MYTABLE" then im trying to run the code.. oops sorry missed a bit, I do the following command before the query refresh Set tbl =...

Hi All again! I am stuck again in a pickle and I have no idea how to get out of it. I am a newbie and this forum has been a life savior. I want the orange table to add a new column and fill it with check boxes each time a new member is added in Blue table. and If a new row is added in the...

Hi all, I’ve got a sheet with 4 tables on it. I have a cell in B2 with data validation set to a list on another sheet. I can currently hide or show the tables based on either columns or rows. As one table is shown the others are hidden. What I’m wandering is if it is possible to hide or...

Hi Everyone, I have an Excel Sheet which contains a range of values as Table, I want to copy those values and replace them in the PowerPoint table(which is the same range as source table). My slide may contain one or more tables so I will identify them using table name, Below is the code which...

I want to delete all rows in a table EXCEPT for the first row in the databodyrange. Using tbl.DataBodyRange.Rows.Count, I plan to delete that many -1. The problem I'm having is figuring out how to select my starting row in the databodyrange down to the last row of the table. I thought of using...