tables

I am very new to using Tables and Queries. Basically I'd like whenever I add a line of data in one table, to have it added to the Power Query Table on another sheet. The other sheet will still have data on it, so the newest data I would like to add it, not replace it. I want to also have the...

Hello, I have two items for my data where I could use some help. Item 1 The data needs turned into a table but the number of rows varies (the columns are always the same). I used to macro recorder for these and tweaked them. First I tried the below but the code locked in the range...

Hello, please forgive my ignorance with this one. I have a situation where I have multiple tables (lets say Table 1 and Table 2 for this scenario) where I need table 2 to act like a clone of table 1. To go deeper, Table 2 must match down to the color and text as in Table 1. All I know is that I...

Good afternoon all, thanks in advance if anyone is able to help me out. I have a problem at work. I have a set of distributions; the distro's are made up of 10 columns. One of them being 'UPC' which is a 12 or 13 digit number. Basically, I have a master file with all the distro's that can go...

I needed to use Power Query to reformat data into a table I can use for analysis. I wanted to add a column where I could type comments, which are typically pasted from a different source. For whatever reason, excel is not allowing me to paste anywhere in the power query table. I can paste...

Hi guys, i need some help. maybe you guys could help me with some idea or in script with vba. I have two tables. one for borrowing table, the other one for returning table. How to avoid double value when i try to fill "amount returned", when in the ID's column has some, same ID. Here's the...

Just like the title states, I have multiple sheets that all contain tables with similar data that can all be connected via a unique identifier. What would be the best way of achieving this in excel? The above image is an example of the main sheet where all of my gathered data will go. I want...

Hi, I pull a report weekly for my role which contains multiple columns of data, each row has its own unique ID. Each week when i pull the report, currently i am manually comparing the 2 tables to see if there are any differences and copying any changes from the new report into the old table...

I have pieced together some code using excel as a file picker to add images to embed within subject body. Everything is working just fine with basic alignment, but I would like to get some help adding these images into a table with a specific formatting Outlook seems not to have a huge support...

I have just starting working with the new excel tables, but have been working with named ranges forever. In the past each cell in the table “Rates” would be a named range, but now are in two columns, “Level” and “Area”. How do I write Rate[Area] =“West” [Level] to return a single value? I am...

Hi, I'm trying to create multiple tables from one master table. It concerns a training schedule where I want to extract lists per person. So the script should loop through the table and select each person and list their trainings. I found code on the web, but it doesn't seem to work. I get an...

I am building a tool that the user can use to create a UTM based on criteria they have selected. I have created a list validation for 2 fields that depending on which the previous selection. The selection is dynamic so what ever is chosen as a "Channel" then the "Description" list will only...

I have a refreshable query table running in Sheet 1. In sheet 2, I have created a vlookup in columns A-H to bring in all relevant information from the table in sheet 1. Column I is where I write comments relating to each line. When refreshing the data, entries that are "closed" are removed...

Please take a look at the attached screenshot I have more than 5 files like this and more than 14 tables in each file I need to compile it in one word file also I have 4 tables I need to get from an Excel file Is there any way to collect the information in each table instead of opening each one...

Hi, first time poster here! I have a data set that gets updated weekly and need the table created in my macro to account for this. Heres the code I've got: ActiveSheet.ListObjects.Add(xlSrcRange, Range("$A$1:$O$104017"), , xlNo).Name _ = "ShotData" Thanks in advance! -Reebs

I am wanting to create a formula that will provide me with the closest date that was prior to the funded date - whilst matching it specifically to that product code only. Funded Date 1/7/2020 Product Code Date of Change Product Name Old Rate New Rate 575 8/10/2019 MSV 3.19 3.04 575...

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