items

I have a rather interesting situation that I can't seem to find an easy solution to. I have a few workbooks that have 3000+ lines of data in them. I need to find a way to pull a count of items that are within a certain distance of other items. As a very simplified example I will use the...

Hi everyone, I got this listbox named lstSearchResults. The data in it comes through VBA from the worksheet "Telephone". I would like to have a button to delete items in the listbox that i select. I found this code; Private Sub cmdDeleteContact_Click() Dim i As Long With Me.lstSearchResults...

Good day! What VBA code can help me if I want to automatically change my pivot table filter to a cell values (which is multiple), sometimes these cells contains value sometimes do not. So sometimes my filter will be multiple items sometime only one.

I'm trying to count how many items have been sold each hour from a report. In example below between 10:00pm and 11:00pm I sold 4 items. I need to do this for each hour. How do I do a lookup for a time range? Thanks in advance! TIME Items Sold 10:41:00 PM 2 2:42:00 PM 1 4:36:00 PM 1 8:02:00...

Hi, We are setting up new location in our warehouse and need to assign items to those locations. Some items will have multiple locations. Each location has a maximum number of cartons that can go in that location. I have a SKU number, number of cartons for that SKU, item locations, and...

Hi all, I'm trying to find the lines of code that would allow me to connect the little connectors of the row 5 to a larger one Here is how works the userform I've created The commandbutton1 allows to put the elements of the textboxes 1, 2 and 3 in the listbox 1 and 2. You can add as many...

Hi all, I'm trying to find the lines of code to link the little connectors to a single one. Here is what I have currently, where the cells above represent the items b of a listbox 2, with a connector for each item, then below there is a cell that contain the value of a textbox. Currently...

Hi all, I wonder how to find the location of a cell at the exact middle of the cells filled above of it. Here is the code of the listbox which allows to put in the row 5 all the items (let's call them b) contained in the listbox 2, with a separated column at each item Dim b%, con For b = 0...

Hello, I have a tricky, well, I think it is tricky formula I need to write. The idea is that any item that starts with "A" and number after "B" and numbers after "C" and numbers after "E" and numbers after or finally "K" and numbers after I would like the letter returned. Everything whatever...

Hi all, I'm currently looking the lines of code to link different items coming from 2 different listboxes. Here is my code that allows to, at least, link items of a single list between them: Here is the macro applied to the commandbutton that displays the items of the listbox in an excel...

I have one of these on my worksheet but there is no code anywhere that would have AddItem'd it. I must have done it but I can't remember how. Tried adding another one as a test but I can't see where items would be added to it. What as I missing ?

Hi all, I try to design an automate structure/organizational chart and I'm just at the Beginning of my project First, Here is the code of the List Box with the button of the macro that displays all the items contained in the listbox Private Sub CommandButton_Click() Dim I As Long For I =...

Hi, I have exported accounts data in excel from accounting software. Now stocks of the items are in Cartons (boxes); please help me, how to convert them into KG because record of all other items is on KG only. Please see attached excel sheet. I can get the sum of boxes for desired products but...

Hello Using Excel 2010 I have these two pieces of code below that put 2 fields into the page area of a pivot table. I want to choose 2 out of 40 items in OrderID I want to choose 1 out of 20 items in CustomerID Is this possible without having to write true vs false code for each item in VBA...

Hello Using Excel 2010 I have these two pieces of code below that put 2 fields into the page area of a pivot table. I want to choose 2 out of 40 items in OrderID I want to choose 1 out of 20 items in CustomerID Is this possible without having to write true vs false code for each item in VBA...

I am pretty new to using macros in my workbook to try and speed up using it. I have a data validation list (C2:C97) called "Description" that has 66 permanent items (C2:C67) that are alphabetized in it and another 30 items (C68:C97) that are added to the list via input on another sheet. When...

Hello, I have a spreadsheet with lots of columns. Some columns need items counted and some need items added. I'm hoping someone can help me with code to count and add cells in a column after the last occurrence of a series of items. Let me explain with an example. The code would start with Col...

I have several branches in a pivot table showing the total profit in a Column and the number of items sold for a particular item in another column I would like to know how to set up a formula to calculate the average Profit on the pivot table for each branch see sample data below...

I have a need to loop through a dynamic range with a formula preferrable. If i have to use a macro i can, but would rather not if possible just for ease of maintenance down the road. My situation is this: "Names" would have a list of names repeated a number of times (variable but is based...

I have created a tracker which allows mutliple selection of items for a given cell. However when I run a pivot on that worksheet What I require is for these items to be displayed independently. However they appear clubbed together in the pivot. Makes it difficult to create a dashboard and...