tables

Can someone please help me? I am trying to import this webpage to PQ but the Navigator lists no tables at all. Is there some special technique? https://www.nhl.com/standings/2019/league

Hi, I have a workbook with 3 different sheets containing tables. All 3 sheets are the same exact format, the only thing different is that it is divided into 3 regions. So column headers are exactly the same in all 3 tables. I am trying to copy all 3 tables into one new sheet. Is there a simple...

Hi, Im trying to filter multiple tables by a common table header cell called "Match:". If the row in any table on the worksheet in column "Match:" is True, then show that row with the table that it is in, otherwise i want the entire table hidden including the first row right above the table. I...

I am creating a userform to record incoming business opportunities across multiple work-streams and need help with the Unique ID feature of the coding (appreciate this is a common question and I have looked, and looked again and Googled - but I couldn't find anything for my situation) as I'm...

Does the iPad version of excel allow for 2 variable data tables? I have a workbook with 1 and 2 variable data tables that are not updating. Similarly, is there the equivalent of an f9 key for mobile Excel?

Hi everyone, Long time reader, first time poster. I have a Power Query (Main Verification Query) which collects data from a dozen spreadsheets, appends them into a table (TBL_Main_Append_Query), and each record has a unique ID. Unfortunately, the Unique iD is specific to each original...

Hi, I have 50 DAX tables. I would like to change the order of the tables. But every time I move the tables. They go back to the original order (order of when created). Is there not a way to set the order of the tables? Thanks

I have a Front_DB_A with a table called RS and another Front_DB_B with a table called RS_Hist, both are split databases and have tables linked to the Front_DB_A database. My dilemma until we can move it to SQL Server which we are waiting on is that I have a run a query that will combine both...

Hi all, I'm struggling with a macro for automatic formatting tables in a Word document. The macro below, while flawed did work when only tables of a certain format where in the Word file. Now other tables have been added and that breaks down the macro. The macro should only format specific...

Hi All, I have searched the internet for a solution but cannot find one. can someone help me with Power Query in excel. so i have separate tables for items which can contain a varied amount of rows. i then have a merged copy of all these individual tables in another tab as one big table. so...

Hi! I want to take tables from a Word document and put them into excel where the columns are transposed to rows in a certain way. The word document has three tables, each of which can spread across 3 to around 20 pages. Each table has two columns. The first has a table number which tends to be...

I have an Append Qry where I am using 2 tables linked by a key and all have it to where I am providing pop ups to enter specific data. However it has stopped working. Anyone have an issue like this before? Trouble shooting has yielded nothing. The data exists in both tables and the data I am...

Hello everybody, I have two tables in the following format: tblSkills: <tbody> Name ID Function Assembly Drilling Polishing Package Jeremy 001 Operator 1 1 0 0 Rodger 002 Operator 1 0 0 0 </tbody> tblPlanning: <tbody> Date ID State 01.01.2019 001 Assembly 01.01.2019 001 Drilling...

Hello. I have an 2003 access database (mdb file) with all tables having Unknown as owner except one table which has Admin as owner. Is there a way I can use VBA to transfer tables ownership from unknown back to Admin?

Hi I have two excel files stored in Dropbox - one a database that is not opened by users and the other a tool that runs two query tables from the database and is supposed to refresh the query tables on auto_open by setting the connectionstring to the users filepath to find the data source -...

Hi, Can someone derive formulas for I3:I8? Thanks Excel WorkbookBCDEFGHI1Table 1Table 2Table 32CodePriceCodePriceCodePrice3X1$ 2.00Y1$ 1.00X14X2$ 4.00Y2$ 3.00X25X3$ 6.00Y3$ 5.00X36Y17Y28Y3Sheet1

Non VBA person here. I think I have stumbled my way into VBA code that does what I want it todo but only triggers manually. I need itautomatically to trigger. I think my reading tells me that the tables don’tcalculate automatically. Is there a wayto calculate table on change to a range...

Hi guys, I'm running into a little but of a problem that I'm hoping someone here can help me with. On a daily report that I run I have 8 different PivotCharts from 8 different PivotTables, all from the same data source but displaying different parts of it. I also have one slicer and one...

Hi, i have some code that a) filters data from the table in one sheet into a group of new sheets named by the filter value b) creates a new workbook from these sheets The script does the above. The additional code has no effect that i can see. It doesnt stop it working, it just doesnt do...

Hi, I have a workbook with several sheets. The example used below is very simplified Each sheet of the workbook has several tables. Each table is composed the same way but there might be more or less names in the tables per sheet. For example sheet #1 might have 4 people. Sheet #2 might have...