We help IT Professionals succeed at work.

problem with Create Monthly Totals

JaseSt
JaseSt asked
on
256 Views
Last Modified: 2013-01-08
gowflow, not sure why but I'm not getting any results for the December Create Monthly Totals function. Attached is the December sheet. Let me know if you need anything more from me to figure it out.

As you can see it saved it as December 2011 not December 2012. Strange.December-2011.xls
Comment
Watch Question

gowflowPartner
CERTIFIED EXPERT

Commented:
What workbbok give this problem like you started December with what workbook Visa or MC ? it would help troubleshoot. As the first one that create the month is the one that give the filename.
gowflwo

Author

Commented:
I first tried it with the MasterCard workbook and it gave me an error so I closed it down restarted it and did the visa also. Upon restarting it did not give me an error message but it gave me the results in the spreadsheet
gowflowPartner
CERTIFIED EXPERT

Commented:
So the visa created the file ?? Are you sure that you date on your pc is the correct date (sometimes we move the date back to print some report especially at end year) hv u done something like this and forgot the old date ???
gowflow

Author

Commented:
no the mc work book created the file. My date is correct on the computer
Partner
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
gowflowPartner
CERTIFIED EXPERT

Commented:
Did it work for you ?
gowflow

Author

Commented:
Not really. Please see attached. Errors from MC run.error 1error2

Author

Commented:
well, ran it again and it worked.
gowflowPartner
CERTIFIED EXPERT

Commented:
so bottom line is what now ? worked or did not work ?
gowflow

Author

Commented:
it worked for December. I'll try it again in February for January.

Author

Commented:
Thanks again, gowflow.
gowflowPartner
CERTIFIED EXPERT

Commented:
Glad we fixed this old issue. Pls let me know any other issue you may need help with.
gowflow
gowflowPartner
CERTIFIED EXPERT

Commented:
Any news ?
gowflow

Author

Commented:
Yes, I have at least a few more to look at, but they take time to explain. I guess I can start with a couple relatively easy ones. Here's the first:

https://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_27989319.html
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.