table

Hi Excel Gurus, I am attempting to set up a spreadsheet where I can update data in tab 1 on a monthly basis, then refresh the pivot in (tab 2). In tab 1, when I paste the new set of data on top (same format), when I refresh the pivot (tab 2), my power query disappears - no data appears in the...

Dear all, Im trying to avoid sending mails out every week with new tasks for people. Therefor i try to create a code that can look at my query data and sent it to the correct person in outlook. I would like to make a code which takes the header and table data for rows with specific name and...

Hi, I would like to sum data in a column based on the results of 2 other columns. Machine 1 Monday 3 Machine 3 Wednesday 2 Machine 2 Monday 5 Machine 1 Thursday 7 Machine 1 Monday 6 So i need to sum column C in a table Machine 1 Count Machine 2 Count Monday Monday...

I have an example table in worksheet (just as an example to demonstrate my query). The table is called Table1 and has 2 columns Col1 & Col2, Col1 containing different integer values. In a cell outside of the table (E2) I have this text: Table1[@[Col1]] Then in Col2 of the table I have this...

Hey Excel wizards, I’m here to ask on how to make a table for my work team that I can’t seem to figure out and it’s been bugging me for days. We have a sales team of 40, and some of us want a daily target tracker. I’m looking to make a table based off each working day quarter where you can...

Hi, I am a total beginner in VBA. I have an excel with two sheets as "form" and "database" (actually more but others are not relevant). In the Form; 1) Users type their username, password, and select the week. 2) In the orange part, users type other stuff (to all 3 rows). 3) When submitted...

Hello everyone I need your help. I have a table (d11 : o70) that has to be filled with values that are in a column in another spreadsheet. The first 12 results go to row 11 from column "d" to column "o", the next 12 to row 12 and so on up to row 70. I could do like this...

I realize this question is similar to what is being asked here and here. However, when I tried to adapt them for my use I ran into several issues. On worksheet "Free IDs" I have Table1 from A1:J21 with headers, data validation and formulas. On worksheet "MASTER LIST" I have Table2 with the same...

Hello everyone I have to populate a table (21 (d to x) x 60 (11 to 72 ) with values from a column (a1) in another spreadsheet. I can use: Sheets("REL_SOCP").Range("d11") = sheets("D_socp_tts").Range("a2") Sheets("REL_SOCP").Range("e11") = Sheets("D_socp_tts").Range("a3") But there must be...

Hi all, I need your help with a table I'm trying to build and need to run it every Monday. I think this can be achieved with VBA. What I need to do: - At the beginning of every month, the table needs to erase the details (or simply don't take in consideration the values as I only care about...

Hello and thank you in advance if you're reading this. I think it will be fairly easy to solve but my Excel knowledge is limited. I work at a production company that can fit 39 "sponges" into one shipping box. Because a production run total changes based on the amount of material we have, the...

I'm new to excel Table. I wonder if it is possible to make a Table to be auto-updated when size of another Table changes? Here is my case below, please see in screenshot (I make it simplified for this question). Excel file is uploaded here: Dynamic Table I have 3 Tables: Properties, ElementA...

I hope that someone can help me with the following problem. I have a workbook with different sheets and tables. A commandbutton copies a ListedRow to another table. I created a small workbook that explains my problem. The code that copies the full ListedRow works perfect. Based upon a "yes" in...

Hey, I bring another problem to you people. I have some VBA code to check the last row of a certain table and create a checkbox in that row, if there are none. Problem is, if a row is created in the midle of the table, no checkbox is created in this row, because it is only looking for the...

Hi, I did use match, index and lookup but now use the xlookup to collate relevant data from different tables for information when adding new data to the new new table. Ie copy contact information to help identify the client to add more data against that client. I have generated an equation...

Hi guys, I have a worksheet that have a big table with employee data. In this table, I have a checkbox where a checkbox is created in column B, in every row (this is done with vba). But I would need to delete checkbox that are after the table (for everytime that a row is deleted in that...

Hi All, Every Monday I receive a workbook that has 3 sheets, and each sheet has 1 table. There are only 3 companies that's data is stored on each table I need to filter each company on each table and then merge the tables for each company so that all 3 tables (on each sheet) for 1 company are...

Hello, I have a button that creates 12 month sheets for a specific year that is entered into an inputbox. The code below enters values (coming from a master sheet list) randomly every workday per month sheet created. I would like to have only unique random values per week, and a minimum of 2...

Hi guys. I have a table with a row for each employee of my company. In each row is created a checkbox in column B (with a macro that runs in every change made on that sheet). Is there any way that I can delete a checkbox if I delete a table row? It doesn't need to be the checkbox in that same...

Hi guys, Trying to check if a date is between a range of dates in a table with date ranges. So, I have a table with two columns, col C is first day of vacation and col D is last day. And I'm trying to come up with a function to tell me if a given date is inside that range. I'm toying with...