Updating purchase order (PO) on the monthly calendar

Perhaps this will do what you want.

You're welcome.

What is you plan for handling future months? Would an updatable calendar be an asset if possible?

Duplicated post.

You're welcome.

I can't test this the way that I would like but here is a calendar that you set the month and year and the calendar changes to match that data. Formulae have been filled in to address the cells of the calendar but the Pivot Table is dependant upon linked data which I don't have.

Hope this works for you.

The first file that I uploaded had unexpected results after I changed the data source for the Pivot table. It now works. You will have to change the source for the pivot table back to the original link (I think) but this appears to work. The first upload totalled the column when there wasn't a match....not good. This just leaves a blank cell instead.

Hold on using the latest calendar. It isn't updating properly from the Pivot table. I will try something different.

I hope that I have solved the updating problem. I have entered a few rows of data for testing but that isn't enough to say that it is really correct. Please test before using.

You're welcome.

I'm glad that it is working for you.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

In a Pivot table you have to be real careful. Use the source data to add to a Pivot table. A Pivot table's purpose is to summarize the source data in various ways. It isn't meant for data entry. In fact some cells will not allow you to enter new data (I have experimented using my own Pivot Tables) while cells with month names just ended up sorting the dates in a rather odd fashion.

Now back to you question. The Pivot table that you have is dependant upon source data. Add the dates to the source data along with the pertinent data for those dates, go to the Pivot Table and right click in the Pivot Table and choose REFRESH. The new dates will be incorporated into the Pivot Table. The Pivot Table will automatically expand down the worksheet to accommodate the new data as required.

To find the source of the data for your Pivot Table in your workbook, if you are interested or don't know, click in the Pivot Table, click on the Options Tab on the ribbon, click on Change Data Source.

The source for your table is actually the PO worksheet. To add new dates to the data in the Pivot Table add them to the data on the PO worksheet then REFRESH the Pivot Table.

If you are wanting to add dates just for presentation purposes you can click in the Pivot Table, hit Ctrl + * to select the Pivot Table, copy it then in another area Paste Values. This will give you a copy of the table but you can edit it as you see fit as it is not longer tied to the source data....it is just a copy.