tables

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

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