1. M

    Error: 'We can't summarize this filed with Sum because it's not a supported calculation for Text data types.'

    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 . I am using it as a guide for my own excel spreadsheet. For my own spreadsheet, I have ticked the box where it...
  2. P

    Chart Showing Users start and finish times

    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...
  3. Johnny Thunder

    VBA Help - Need to Add an If Statement to my Working Code - Add value if not found

    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...
  4. 0

    Looking to learn: My code works, but can you speed it up?

    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...
  5. D

    vba on datasource

    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...
  6. C

    Pivot chart - how to change data source

    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...
  7. L

    Combining lists of variable lengths

    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...
  8. Default300

    ?Use Dynamic Named Range as Table / DataSource in MS Query?

    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...

This Week's Hot Topics

  • separating multiple Proper names (uppercase letters) from a list
    I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into...
  • 'for' Loop
    Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to...
  • Open specific pdf in folder with vba
    Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it...
  • What is wrong with this For Loop code?
    I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a...
  • Data to match
    Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I...
  • Shifting Columns
    Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back