tables

My code deletes all but the first row of my table, tblETS. But when the code runs I get prompted with "Delete entire sheet row?" I've deleted rows like this before but this is the first time it's prompting me. How can I keep that prompt from popping up? Private Sub PrepMyTable() Dim wsCopy As...

Hi all, I got some code that helps copy an excel table and create an email from it. My only problem is that I can't seem to find the way or what part of the code to modify in order to keep the columns width and avoid the table going narrow. Thanks in advance! Below both codes I use: Sub...

Been away from Excel for a while and now trying to get re-started ... I have a worksheet table with numbers that I want to add a column to, perform a calculation for each row in the table and then convert the cell contents to values. I will add more columns to the sheet for other calculations...

Dear All, I have a table1 in sheet 1, on which I paste data from a table2 in sheet 2. Sheet 3 is the summary sheet, which have formulas referencing to table1 in sheet 1. The problem is, if I paste data in table1, the formula does not work on Summary sheet. But if I manually type in table1 then...

Good afternoon.. 1st Post: Helping out a friend with a mentor program, but I need help compiling live data from 100 sheets into one sheet. Here is what I have: I have 100 sheets in a Microsoft Excel workbook (saved to a OneDrive folder) that use identical column headers in each table. See...

I have two tables one in B1:G1 and the other in L1:T1, both go down hundreds of rows. If I only had one table I could delete a row, but it seems if I have two tables I can't delete one or more rows. I need to delete the row from BOTH tables, not just one of the tables. I saw some VBA to...

Hi all, So I have a table similar to the below which acts as a matrix, so Req ID 1 is in F1 but could be in any number of Fx, up to about F80. The status of a Req ID can be updated The Team X is the team who is interested/working on the particular Req. Req ID Status F1 F2 F3 F4 F5 1 Agreed...

Hello, I have a table with many fields, and each record in the table has a unique ID. I want to find the intersection of a particular ID and a particular field , and then copy and paste a value into the cell where they intersect. In the attached example, I need a macro that when run, the name...

Hi, I have data arranged data table how do I calculate the averages of C,D,E and F and tabulate it by year and month as in the Average China Prices table? Thanks for you help BCDEFGHIJKLMNOP3PO Spot Market Price (unit: RMB/mt)Average China PO prices RMB/ton SCI4DateShandongNorth ChinaEast...

I was asked to keep track of a project and need to report on its progress every month. The raw data will be names, office locations, current model assignments, new model assignments, and the date the new model was reassigned. Initially, I was going to create monthly tables based on this data...

Certain Excel 365 licenses offer Office scripts, which is an implementation of the TypeScript language to automate Excel, just like VBA does. I am planning a small series of articles focusing on relevant TS features and their application to the Excel object model; this first one will deal with...

Hi all, I currently have a table of data containing customer orders; dates, names, stock quantities, customer order quantities, an IFELSE statement that shows whether an order is complete or not, etc. I have a Power Query set up that pulls the data from this table, and IF all of the orders for...

Hello everyone, long time no post! I have a situation, which I would think can be solved rather simply, but I can't figure out a way to do it. I have several POS systems and how much they are able to sell. We also have the knowledge of how much volume we do every weekday, every month that...

I am trying to build a dynamic table that changes based off of what you select in a drop down but it pulls data from different tabs. I can make it work when it is just looking at 1 tab but I would have multiple people populating their own tables on their own tabs so I want the home page to show...

I am still a newbie to most Excel functions. I have created a workbook with IF Statements, VLOOKUPs, Concatenates, and VBA Codes. However, due to an annual rate increase, I need to create a complex IF Statement for just this month and I can't quite wrap my head around how to do it. Currently...

I'm not sure how to ask this without just jumping into the problem... So here it is: I have a table that has door types and corresponding info for said door types. that data is linked to another table that has a drop down. So if you have 3 "Type A"s and 6 "Type B"s, you only need to type the...

I'm trying to create a new table of dates of the first and last day of the month. The date range for this new table is from the "Date Created" field of a separate table (Table 1) which is from an external data source. I'd like the new table to be dynamic so that as Table 1 is updated, the date...

Hi All I have two tables i am trying to look up one for the other. Table A is a list of licenses by Country with the Product names for each. Table B is a list of the Product sales. The same Product code can be sold in different countries are in same cell separated by a semi colon. Does...

Hello excel experts, I have a VBA code via the magic of ChatGPT: Sub DuplicateTemplateSheet() Dim templateSheet As Worksheet Dim newSheet As Worksheet Dim sheetList As Worksheet Dim sheetName As String Dim lastRow As Long Dim i As Long Dim tbl As ListObject ' Set a reference to the Template...

Hey everyone, hope you are all fine. I have 2 Tables: MasterTable UsadasTable I need, on each click on command button, to cut values on MasterTable B4/C4/D4 and paste to UsadasTable I4/J4/K4 On the next click, i need cut the values of the next row from MasterTable B5/C5/C5 and paste to...