I've been working on a problem for several days now and can't seem to figure it out. I believe it is going to take VBA to do. I have several different part numbers that have different dates below (dates represent 1 unit of inventory). I need to combine the dates (always changing) into a single column in a different tab for each part number. I've messed around with if statements and hlookups and had zero luck. Any help would be much appreciated.
Screenshot 2016-03-24 at 7.08.39 PM.png
Last edited by tmor; 03-24-2016 at 09:09 PM.
could you send the excel file instead of its picture?
Hi tmor,
Welcome to the forum!!
Post back re how this goes:
Regards,
Please Login or Register to view this content.
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
I am getting a "Run-Time error "9": Subscript our of range" message. I am very inexperienced with VBA. From the reading I've done it looks like the array in the code does not match with the sheet. I am currently at work and can not upload the sheet to show as an example.
Looking more into it i figured out the subscript out of range problem. It is running but not organizing the data correctly. I'm going to dig around a little more
You need to change either the sheet name the wsSource variable is pointing to (i.e. Sheet1) and / or the sheet name the wsOutput variable is pointing to (i.e. Sheet2) to the exact sheet(s) name(s) that is applicable to your data. That's why I put the comment 'Change to suit if necessary' next to the line that sets those variables.I am getting a "Run-Time error "9": Subscript our of range" message.
It worked fine for meIt is running but not organizing the data correctly.Until we can see a sample of your data it's very hard to provide any kind of a solution.
HTH
Robert
Last edited by Trebor76; 03-25-2016 at 07:15 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks