Adapt this clean code from read to read + sum:
--- The code below reads the 8th column and brings to a new sheet a quick big array with all the columns that have this cell filled.
What's needed is for every product stored in the 1st column... I need this code to sum the same 1st column names' 5th column values to have the current 'product availability'
Please Login or Register to view this content.
Best way to get an answer that makes sence and to avoid back and forth messaging post an example file that reflects the situation.
Create Before and After sheet. Mock up data if there's a problem with sensitive info.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Uploaded them as pictures for you!
Basically the output.. would be on the 2nd page.. with every product name and their total sum (either positive or negative if we sold items that we have not got in stock)
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
I did that as pictures above! The file xlsx was 5 mb even after I reduced it into a new workbook so I couldnt upload it, but it's the same as watching the pics right? the code above is what needs to be adapted but I need your help for that part..
are they good enough?
Hi and welcome to the forum
Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please upload a workbook instead. It doesn't have to be the actual workbook, just the same layout so that your code works and demonstrates what you want it to do.
We don't need the entire file, just a few hundred rows will do.
Just a wild guess. Adapt sheetnames and ranges appropriatly.
Please Login or Register to view this content.
First of all, thank you so much for your replies, I tried bakerman's code but it gave me the following error while selecting solely '.keys':
5I9znTg.jpg
So I've attached the excel example of the real code...
What's needed: to get a report for every product on the list for it's current stock availability. One sheet includes all the products we've bought and sold on the same list, the next sheet is for the report
My bad.
Please Login or Register to view this content.
Last edited by bakerman2; 05-24-2018 at 07:52 PM. Reason: Typo
Wait... I fixed it and Im reviewing the results!
Last edited by 1.jclozano; 05-24-2018 at 11:03 PM.
Is Sheet1 the correct sheetname ?
Last edited by bakerman2; 05-24-2018 at 11:03 PM.
Yes but I was using the 2nd name of the sheets.. the base name
Then just change thisTo thisPlease Login or Register to view this content.
Please Login or Register to view this content.
Is it possible if you can tell me how may I adapt this code to give me the same availability but for any product name that is on the list that I can choose?
I' currently counting to check if it's summing correctly
it looks really good it takes 1 second to finish or less!!!! Thank you so much bakerman da man!!!!!!
Your code is too succinct/advanced for my knowledge
Last edited by 1.jclozano; 05-24-2018 at 11:25 PM.
Select a product in combobox on sheet1.
Result is displayed in MsgBox.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks