source data

  1. D

    SUMIF for closed workbook

    Hi, We have several target sheets that run using the formula below. I have been told that they always used to work without having the source book open but from researching online i dont see how it was possible as they have always been using sumif. could you have a look at the formula below and...
  2. S

    How to find where excel data is fed to.

    So there are bunch of ways to find where excel file data is pulled from, but I found none to find where data is fed to. I want to rename an excel file, but I want to also make sure other files that are linked to that file will change the file name.
  3. DPChristman

    Vlookup issue - Retail Environment

    I am currently trying to link data between a large data file and a fill in form that I have created. The source data is coming from an excel file that is over 34 MB and more that 177,000 lines. This data deals with inventory shrinkage. There are 7 columns that I am accessing on the source...
  4. S

    Change Data Source in Pivot Table

    Hello, I'm trying to find a seamless way to change the data source file in a pivot table without manually going in and editing the text via Pivot Table Tools -> Options -> Change Data Source. Ideally, I would somehow build a reference using a HYPERLINK-CONCATENATE formula that I build, either...
  5. P

    Some columns gets blank in pivot source data

    I have existing excel (ver 2010) with pivot. This excel is refreshed programmatically from c# application. The pivot is created with OBDC with sql stored procedure (which returns the sql table after performing some business logic) to pull the data. When the excel is refreshed programmatically...
  6. M

    VBA to change multiple pivot tables from multiple sources

    First I apologize for being very new to VBA. I have two workbooks that need to stay separate. There are 4 data sources in one of the workbooks and the other workbook has several pivot tables that reference them. Each week, I need to save a new file with that week's name. Every time I do this, I...
  7. M

    SOS Set SourceData Chart

    Hi everyone! How are you? I am working on a financial report with +100 worksheets where I use a For Each loop to create charts on every worksheet. I had one that worked excellent but now that I added some extra columns to the pivottable which I don't want to add into the chart, I had to change...
  8. J

    VBA to change source data of PivotTable

    I have a Pivot Table that's source is a table called "Data". In my code, I convert this table to a range, perform a variety of functions, then convert it back to a table with the same name ("Data"). I want the code to automatically update the source data of the Pivot Table to the new "Data"...
  9. R

    Refreshall Twice

    HI , I have 5 pivot tables , 3 are connected on 1st raw data and other 2 are connected on 2nd raw data and I am trying to refresh them using both Excel refreshall button or Alt+f5 and I even tried macros(activeworkbook.refreshall) but It's not working for the first try , All I need to do is to...
  10. J

    Consolidation of range with a twist

    Hi Folks, I have been trying to use pivot table consolidation from multiple sources but didnt manage to get the desired outcome. Im happy with any hint of solution, vba or formula / wizards... I have 3 sheets in excel where you can find similar type of data at the same locations. This is...
  11. C

    SourceFile problem after changing a macro

    Hello all, I've been trying to change a pre-existing excel file to make it work with different source data. It is a timesheet master file that gathers data from a set of separate excel sheets which are each individual timesheet, and builds a report based on that information. I changed the...
  12. G

    Power Pivot Excel 2013 - Source Data issue

    Hi - getting familiar with PP for the past few weeks. Got about 4 books that I've gone through, but none really address the issue of "When source data changes..." I've got a source data file where column headers change each month. It is a 36 month rolling report, so last month had "Dec 15" as...
  13. J

    Adjusting Pivot Table source data based on cell value

    I'm trying to adjust a reporting file that currently looks at raw data for a one week period and generates reports through pivot tables. Each week's source data has to be on its own sheet, so traditionally, a new file is created each week. Other parts of the file generate data on a two week...
  14. S

    Display Source of Pivot Table in a Cell

    Hi there, I am curious if anyone can help me with a formula that could find the source of the Pivot table and put it in a cell to show that it selected a specific range of source data. What I am doing is that I have a Pivot with VBA buttons that switches between two source data tabs, "Actual"...
  15. J

    Can't select data source for chart

    Trying to get some help for a friend here. He is running Excel 2010 and has an existing chart with no data associated with it. He right clicks on the chart and clicks on "Select Data". The Data Wizard pops up and he clicks the Chart Data Range Icon (the one with the small red cell in the...
  16. F

    Specify Selection as Range in Pivot Table Macro

    Hello all, I want to specify the active selection as the range for my pivot table but I keep getting an error message. Funny thing is this recorded code always used to work before but for some reason its not working anymore. The only change I had made in the recorded code was changing source...
  17. S

    One time Data pull without link

    Excel 2007. Trying to create a report workbook that pulls data from other source workbooks, but I would like to be able to disseminate the report workbook to other networks without including the source workbooks as they are massive. Current setup: I am having the report workbook pull data using...
  18. J

    Using a variable within Pivot Table Source Data property

    May I request assistance on using variables within a Pivot Table Source Data property. I am receiving an error when using the following code 'Create Pivot Table off of Consolidated Employee Data Dim LR As Long Dim LC As Long LR = Range("A:AO").Find("*", SearchOrder:=xlByRows...
  19. G

    Modify PivotTable double-click behavior --OR-- ...

    Hello, I need some VBA code to address the following: Scenario: A pivot table reveals a probable error in the underlying source data. The error needs to be located and corrected in the source data, and then the pivot table needs to be refreshed. *Problem*: The double-click action on a pivot...
  20. L

    "SourceData" and "TableDestination" for PivotTable

    I download data from a web site on weekly basis and break information down by branch location and employees assigned to each branch-- Data source will fluctuate depending on new hire employees and those that quit or get laid off. I used macro recorder to help create this section of VBA to help...

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 MrExcel.com.
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 "mrexcel.com".
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
Top