table1

Hello, I been whacking my brain on this little problem for a few days now and about to cry So i have 2 tables Table1 <tbody> Month Name Hours 1 Joe 3 1 Jack 4 2 Joe 5 2 Bob 3 2 Nancy 6 3 Jack 4 </tbody> Table2 <tbody> Name Jan Feb March Joe x Jack Bob Nancy...

Hi, I have a sheet with several rows of product codes. In several columns I have components for each product row and the number of components used per product. I would like to get the data from the columns into a single column with several rows. It's probably better if I explain as follows...

Hi there, Sorry for the naff title - this is my first post and still a rookie in the VBA world! So I'm trying to write code which creates a pivot table and places it in a predefined location (not a new sheet). Before running the macro each time, the pivot table is deleted. The issue: This...

Hi everyone I am trying to get an Index Match from a table based on alphanumeric values contained in the lookup value. Sheet2 Table1 ColumnA Header[Item] contains the lookup array Sheet2 Table1 ColumnB header[Shape] contains the return value array Sheet1 ColumnA contains the lookup value...

Hi, I have two sets of table, one with few rows and its corresponding percentages (This table varies time to time i.e. number of rows, percentage etc), The other table has fixed 11 rows with percentage values. Illustration below: Table1 (Dynamic) 500,000 - 10% 1,000,000 - 15% 2,000,000 -...

I have two tables, Table1 and Table2, and I want to set all of the column types of Table2 the same as Table1. All columns will be the same. What's the easiest way to do this? I was thinking of something with Value.Type(Table1) but I'm not sure how to use that in Table2. Thanks

I am using Power Query to compare column values in two tables, where each table has a Key column as well as around 20 dimension columns, which I want to check to make sure that the dimensions align between the two tables for each Key. For example Table1 <tbody> Key Dim1 Dim2 Dim3 ABC...

Hello, I've been googling this for a little while now and can't seem to find what I am looking for. I'm hoping someone can give me some direction as to where I can find this information or if they can provide some information on this topic. I am trying to create a query in access 2010 to see...

Hi I have two tables (Table1 and Table2) on 2 different tabs (Sheet1 and Sheet2, respectively). Table1 <tbody> Name City Line District James Boston Hard Goods John Los Angeles Soft Goods William Baltimore Soft Goods Harold Miami Hard Goods </tbody> Table2 <tbody> Name City...

I have a couple issues that I will explain using the names Table1 and Table2 for easy understanding. I want to check if object Table1 exists, and if it does, to change its name to Table2 and Select it as well. How can I achieve this?

Hi, I've created a new table (table2) by transforming data from an existing table (table1). I would now like to append some other data to table2 from table1. I can do this quite easily by creating a new table and combining the two tables, but I'd like to do it all within one script to avoid...

Hi all Four table is my file as follows Table1 : Sales2016 Columns : StoreID Date Sales16 <this has 400 stores daywise sales Table2 : Sales2017 Columns : StoreID Date Sales17 <this has 400 stores daywise sales Table3 : StoreMaster Columns : StoreID Manager_Name Province...

Hello all, I have the below update query, updating some data from table1 to table2 when the later are missing. But some times some of these data are not stored in the table1 but in another table, table3. So I would like to know if there is a way to run at first the first query and if it...

Hoping someone will help me with this... A1 = a user defined date (mm/dd/yy) Table1 = a defined table range in which the values are either blank, or are dates (mm/dd/yy) I need VBA to consider the date that is A1, and then look through Table1 and change the font color to red, of any cell in...

Hi, I'll need some help in Excel. I have two tables with their own filtering/sort options for each columns. Outside this I'll need to generate a a table with filtering/sort that can calculate the total amount from one ID in table1 + table2. The issue is that whenever I filter either table1 or...

Hello, I have a file with three sheets. Table1, Table2 and Table3. If the cell "C2" of "Table1" has a value cell "C2" of "Table2" will get it too via the formula "=Table1!C2" Now I want that if cell "C2" of "Table2" has no value row "6" of "Table3" gets hidden. I had it working within the...