Avatar of JaseSt
JaseSt
Flag 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
Microsoft Excel

Avatar of undefined
Last Comment
JaseSt

8/22/2022 - Mon
gowflow

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
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
gowflow

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
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
JaseSt

ASKER
no the mc work book created the file. My date is correct on the computer
ASKER CERTIFIED SOLUTION
gowflow

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
gowflow

Did it work for you ?
gowflow
JaseSt

ASKER
Not really. Please see attached. Errors from MC run.error 1error2
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
JaseSt

ASKER
well, ran it again and it worked.
gowflow

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

ASKER
it worked for December. I'll try it again in February for January.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
JaseSt

ASKER
Thanks again, gowflow.
gowflow

Glad we fixed this old issue. Pls let me know any other issue you may need help with.
gowflow
gowflow

Any news ?
gowflow
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
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