I have made this receipt which I attach and after using it for a while I notice several flaws like being sometimes hard to use vba code in it due to merged cells or, most importantly, the mess that merged cells create: cant organize by date because of merged cells, cant copy one row to another because it says its not the same size (I SWEAR all the columns are the same size and merged the same way).
I also noticed that other companies organize each receipt in their way so I was wondering how well organized is mine. I want everything to be in its place but I also would like to avoid merged cells and text boxes (i need all the data referenced in cells for code). The most annoying thing in this case is the mailing adress which in some cases is very long and have o use several cells, I use 3 vertically merged in this case.
What would you change to improve it? How would you get rid of merged cells? The columns in the receipt "concepts" I attach are all needed in that width. In fact I would need one or two more boxes but it didnt fit, I sized all columns very tight because I dont want to lower the text size.
Thanks you
receipt.xlsx
Bookmarks