+ Reply to Thread
Results 1 to 3 of 3

Inventory Spreadsheet - Transfering count to master broken?

  1. #1
    Registered User
    Join Date
    11-16-2009
    Location
    United States
    MS-Off Ver
    Excel 2004
    Posts
    24

    Angry Inventory Spreadsheet - Transfering count to master broken?

    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!
    Please Login or Register  to view this content.
    Last edited by turningitred; 11-19-2009 at 01:25 PM.

  2. #2
    Registered User
    Join Date
    11-16-2009
    Location
    United States
    MS-Off Ver
    Excel 2004
    Posts
    24

    Re: Inventory Spreadsheet - Transfering count to master broken?

    Bump no response

  3. #3
    Registered User
    Join Date
    11-16-2009
    Location
    United States
    MS-Off Ver
    Excel 2004
    Posts
    24

    Re: Inventory Spreadsheet - Transfering count to master broken?

    Nevermind, I finally figured out what I was missing!

    Variable mr was not being reset in the loop, therefor it would only loop once. Also, I had the ArchiveInventory function clearing out the inventory after archival and before transferring the count over. The count sheet is based on cell references that only show the item if there is either an item in inventory or a par set, so after clearing the inventory, the count was blank. woohoo! I'm an idiot! Anyway, this is the code after fixing in case anyone is interested. Feel free to share any other ideas if you have them, thanks!

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1