Here is yet another workbook I've been working on where I wrote the macros and they worked and now they don't. More specifically, when I went to add the count to the inventory, it keeps returning an error where the date is pasted from one sheet to the other. I had originally tried to reference the value of the date directly, but because it was being passed to a merged cell, Excel didn't like it too much, so I had it copy and paste it. That worked at first, now it suddenly doesn't.
If anyone could take a look, I've attached the workbook in all it's infuriating glory. Go to the count sheet, click the Add to Inventory button, and see what you get. I'm not great with VBA, but as you can see, I've been messing with it a good bit. Hopefully someone can see where I'm going wrong. Also, if anyone has any ideas to make to code function better, I'd love to hear it!
---Ok, so I've tried to attach the workbook about ten times now and I'm thinking it might just be cursed! Here is the macros that I have written. Hopefully someone can at least see something from this!
Bookmarks