datasource

Hi all, Really need help since I can't solve it by myself :( I am not familiar with VBA and most of time I just try and error or search how other people write the code.. but i am stuck here. I have 4 pivot tables (ABCD) in the same sheet and connect to 2 different data sources. There are 4...

Hi, I have found a macro that does convert columns into rows, bur when i load the data from a sharepoint-source, than i got a table and than the macro doesn't work. The macro is : Code: Sub test() myColumns = 7 'Number of columns to the right of A on sheet1 myRow1 = 2 'First row of...

Hey Everyone, I am trying to attach a slicer to 2 Pivot Tables based on different data sources. I am following the method as shown in this Youtube video https://youtu.be/p9VD0rsC_bk . I am using it as a guide for my own excel spreadsheet. For my own spreadsheet, I have ticked the box where it...

Hi Guys, I'm having a bit of a brain strain with this one so I thought I would try and get some help to point me in the right direction. I have a SQL Database with a table containing a data with user IN and OUT times My data looks like this in an SQL Query <tbody> Username Change Time Status...

Hi Everyone, I am wrapping up a project and need a little help with adding an if statement to my code, not sure the best way to do this so was hoping for some help. Background Using the find method the code loops thru a list of values in sheet "DataSource" and when a value is matched on Sheet...

Hello - my code below works fine and runs in under 8 seconds. However, I wanted to see if anyone wants to take the time to teach me better coding techniques with the hopes of speeding this up or eliminating Excel calculations. Background: I have a master list ("Datasource" tab) with...

Hi All I have connected Microsoft Query to download from my SQL Server with a Parameter from a cell. However, when it runs it deletes all the information within the table. But what I want it to do is append the date to the end. Basically, cell A2 has a DateID based on the formula =max(N:N)-8...

Hi, after I created a Pivot Chart from a Pivot table, I like to keep the format of the Pivot Chart but want to change to a different Pivot table, how do I do that? this is what I tried: PivotChartTools - Design - Select Data, in the Select Data Source dialog box, Chart data range is gray out...

Hi all, This is my first post, so hope this makes sense. I'm trying to combine 2 different dynamic lists into one, from 2 different data sources, but with one unique column ID ref. eg Page 1 shows: Staff # / Project / Hours worked Page 2 shows: Staff # / Project / Expenses claimed The...

QUESTION: Is it possible to use an Excel Dynamic Named Range as a Table / DataSource in MS Query? AIM: I would like to use a Dynamic Named Range to trim superfluous (blank) rows from the Table before MS Query queries it. I was able to achieve close to what I wanted with a Static Named Range...