tables append consolidate

Good afternoon.. 1st Post: Helping out a friend with a mentor program, but I need help compiling live data from 100 sheets into one sheet. Here is what I have: I have 100 sheets in a Microsoft Excel workbook (saved to a OneDrive folder) that use identical column headers in each table. See...

I've been adding monthly tables to a YTD table/dashboard and when I tried to do it today i got the following message "Cannot complete operation, a table cannot overlap with a PivotTable report, query results, a table merged cells or an XML mapping." I have been doing this for months... what is...

Hi, I have Table 1 and Table 2. Both have different data. I want to create a table 3 that includes both table 1 and 2. The end goal is for table 3 to automatically update when I update table 1 or 2. Below is a view Would appreciate all the help! thank you!

Hi there, I'm trying to have a VBA-free Excel file where I can get values from four different tables into a single one (master) that will update as and when new values are added in other dependent tables. I have tried the following formula but it does not work for all four tables I need...

Any help / guidance would be appreciated - I know there is lots of ways to do this, so hoping for a nudge in the right direction. (I'm using Excel 2007) I have a workbook with 6 worksheets each with a connection to a Sharepoint table where users can update information. Each Sharepoint table is...