tables

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...

Hi Excel brains trust, My company have created a Report generator using a spreadsheet + VBA/macros. To use it, our employees fill in a row, select a template from a dropdown, enter the reference pertaining to it, and then click a "Create Document" button. The code then reads which template is...

Let's say I have a list of item (B, D, C) that I import into a new table using Power Query, and sort them alphabetically. Then I add a new Note column, and write a note regarding item B. Later on, I add a new item to the original list (A), and refresh the query. The note about B stays...

I have a problem with some workbooks I am working with. These workbooks have multiple tables in a single sheet and some of the tables have blnk cells and I would like to be able to delete these blank cells with vba, the only problem is that I can't delete the entire row, because I may delete the...

All, I have a tricky VBA Code Scenario. I'm trying to define a table range then loop through all columns in said table range and change the formula in the total row of the table. The Tricky Part is my Table Self Updates so the number of columns and the label of the columns change depending...