Use this code to merge the data based on the name of the product in column No. 8 (H), and collect the data in columns 13 and 14, and the merge appears in a sheet named Temp and appears in the list box.
The problem is that when the supposed combination appears, 6 products appear, but what happens is that only 3 appear
Last edited by saftawy1; 03-13-2023 at 11:22 AM.
Hi saftawy1. It will be difficult to help you:
a) You say you have 6 items but you have 5.
b) In the 'Temp' sheet, the 'Binder' element counts 509 units, but its pivot table says it is 722.
c) On the 'Temp' sheet, the 'Binder' element appears with Rep = Morgan but on the 'SH1' sheet it has Andrews, Gill, Howard, Jardine, Jones, Kivell, Morgan, Parent, Smith, Sorvino and Thompson.
In summary:
1) Your VBA code doesn't matter.
2) Upload a workbook again to the Forum with the expected end result.
3) Explain -exactly- what type of filter you want to apply in your user form.
You are always very welcome if you add reputation by clicking the * (bottom left) of each message that has helped you.
Thank you beyond Excel for your interest. I checked all points and found that the code does not achieve what I want
Therefore, I modified what appears in the list box, which is the columns from H to P only, and what is required is to merge this data if Button 1 is chosen according to the return H with File or the first column in the listbox for the item and collect the other columns except for the two columns J and L to take an average for them as it is Shown in pivot table, I Uploaded a new workbook
And thank you very much
.
See if what I attached helps you:
Last edited by beyond Excel; 03-13-2023 at 05:03 PM.
When opening the file for the first time and trying to open the form, it gave me an error as in the first picture, and when closing the file and opening it a second time, and trying to open the form, it gave me the error as in the second picture.
Thanks beyond Excel
Last edited by saftawy1; 03-14-2023 at 08:18 AM.
The links to your images don't work.
i upload a new picture with the 2 errors
thank you
Last edited by saftawy1; 03-14-2023 at 08:47 AM.
I see your Excel is from Office 2016.
But - this is what you have to comment on - it seems to be a 64-bit Office.
If so, then 32-bit components such as the ListView used are not supported and I would have to change everything and use a ListBox instead.
Personally, while I may have a setup similar to yours, I prefer to use 32-bit Office to avoid these limitations.
it is 32 bit
Attachment 821646
ty beyond Excel
Last edited by saftawy1; 03-14-2023 at 04:20 PM.
.
But that's great: one less problem!...
In case you can't find the correct reference, you should download the MSCOMCTL.OCX control from the https://www.fmsinc.com/MicrosoftAcce...rols/mscomctl/ site and follow the steps in this tutorial.
ok ty i will try that
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks