monthly report

  1. L

    VBA to update file path for pivot

    Hi I was wanting a vba code to update the data source for a pivot in a file so that it points to the current month. E.g, I have a file called 'Manufacturing Month end May 2017'. This file is saved under C:/Accounts/May 17. There is a pivot in that file pointing to[C:/Accounts/May 17/Raw...
  2. J

    How To Make Monthly Report

    I Have a data sheet called 2017, in the R column there is the months. There is a January sheet i want this sheet to extract all the data from the 2017 sheet if in 2017 sheet column r it says January. here is the file you can check it out im so confused... Click Me
  3. L

    I need help to create monthly projections

    hello excel gurus, I have a number of contracts with different start dates, terms (monthly) and $$. What I would like to do is to have monthly projections of my revenue as I continuously accumulate more contracts. How do I go about this? Please help. Thanks in advance!
  4. B

    Getting the Earliest Date on a Selection with Today() as Reference

    Hi Excel Gurus, May I ask for your help, please? I am currently using MS Excel 2007 and aiming to add a formula in a spreadsheet (I am not an VBA expert, I'd prefer to use formula instead of VBA coding but if there's no choice, I'd like to know it also). I need to get the earliest date...
  5. G

    monthly report with text boxes in excel

    I created an excel file for each manager in the department to enter monthly information, some of which is in text boxes within excel. I linked the text boxes to a monthly report word document by selecting around them and pasting special in word as a linked picture. But if I want to use the...

Watch MrExcel Video

This Week's Hot Topics

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