Link to home
Start Free TrialLog in
Avatar of JaseSt
JaseStFlag for United States of America

asked on

problem with Create Monthly Totals

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
Avatar of Jacques Geday
Jacques Geday
Flag of Canada image

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
Avatar of JaseSt

ASKER

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
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
Avatar of JaseSt

ASKER

no the mc work book created the file. My date is correct on the computer
ASKER CERTIFIED SOLUTION
Avatar of Jacques Geday
Jacques Geday
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Did it work for you ?
gowflow
Avatar of JaseSt

ASKER

Not really. Please see attached. Errors from MC run.User generated imageUser generated image
Avatar of JaseSt

ASKER

well, ran it again and it worked.
so bottom line is what now ? worked or did not work ?
gowflow
Avatar of JaseSt

ASKER

it worked for December. I'll try it again in February for January.
Avatar of JaseSt

ASKER

Thanks again, gowflow.
Glad we fixed this old issue. Pls let me know any other issue you may need help with.
gowflow
Any news ?
gowflow
Avatar of JaseSt

ASKER

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/questions/27989319/update-of-previous-solution-for-Mastercard-spreadsheet.html