This question is related to this Thread: https://www.experts-exchange.com/questions/29072079/Excel-Not-sure-this-is-possible.html
and I have someone who is helping me with it.
Ejgil Hedegaard, Attached are 2 files the Excel file with the examples and a PDF that is a watered down version of our receipt, but you can see the columns that need to be filled in.
Here is what I wrote in the message to you:
"ll attach the file I made up here, and if you can help me that would be great! This only differs in the fact that there are a lot less records, and some are already just one line. These are a weekly receipts, and the org that does these, does our year end letter. and would like the file for that to be like the one we did for the year end that you helped me with. It is still run by the account number, and all the fields in this report are needed, and do duplicate some of the fields on the previous one you helped me on. I can start this in a thread, but thought I'd start here. Please let me know if you need any other info."
The date filed should just be the date. Ex. 3/15/18 or 3/2/18 no zero's is fine.
Oh, can the amount fields but done in "currency" format? $300.00 $2,000.00?
I'm attaching the receipt so you can see where those different columns fit in. Can the macro do those calculations?
Let me know if you need anything else from me!
Thanks so much!!!!