updating data

  1. T

    Updating Data Source of Pivot Table

    <tbody> <tbody> Hello everyone; I have question about pivots. I have one excel file which consist 4 sheets. In 4 sheets have more than 10 pivot tables. Every 15 days , my source data is changing(adding new datas) but I have to update new data source one by one manually for 40 pivot tables. Is...
  2. M

    Adding massive amounts of updated data into master sheet

    Hi everyone. I just started using excel for my new job and it's quite overwhelming because 1) the amount of data is MASSIVE and 2) my previous experience with excel was for only simple tasks. My current problem at work is that I have one master sheet with three different products showing how...
  3. B

    Dynamic chart always looking 3 months back and 6 months forward

    Hey guys, I have been working on this one problem the entire day and I am completely stuck at the moment. I have tried solving it and asked my coworkers, but they were also out of ideas. I know I am not anywhere close to being an expert Excel user, which is why I was told that you guys on this...
  4. S

    Powerpivot-Changing Dates and Audit Scores

    I am having an issue with how to get excel's powerpivot to calculate the most recent date with UPDATING and historical data.I have created a powerpivot to show suppliers audit class scores but when those suppliers are audited multiple times over the years the score changes and I need the...
  5. C

    Updating a master spreadsheet

    Hi, I'm trying to update a master SUMMARY list with daily data from another tab and I'm not sure how to approach this. I thought of VLOOKUP, but the data to be posted (DAILY DATA tab) will not be in sequence. So my goal is to run this program to take each day's daily data and post it to the...
  6. L

    How to make my report completely fluid

    I'm having a problem every time my P&L statement updates. This report pulls from 3 tabs (month to date, quarter to date, and year to date). The MTD tab pulls from an outside data source (Cognos) and QTD aggregates that data for every three months, and YTD aggregates for every 12. Everything...
  7. K

    Updating Macro while Excel is closed

    Hi all, Is there any line item in VBA that we can add that will allow the macro to run and the file to update during times that the file is closed. For example, I would like to update some data every two weeks, however, do not wish to keep opening this file and manually refreshing it. Thanks...

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
Back
Top