I am looking for some help on a macro for a pivot table that reports previous and current month based from an already existing datasource (Column "REPORTING MONTH"; format is m/dd/yyyy)
I would like to see if I could designate the previous month as 2 months from the current month (today) and the current month as being 1 month from today.
The Macro below does not seem to work. Any help is appreciated!
Last edited by angeleenmc; 05-26-2015 at 12:55 PM.
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thank you for the tip! I took out the macro since it is not working and I am not even sure it would be correct to use.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks