item

How can i rename an item in a listbox that is already loaded on a userform with a textbox value?

I have a sheet that can contain upwards of 1500-2000 rows. I am trying to get VBA to filter based on certain if criteria matches items pull into an array. Part of my code work perfectly since the column (Column U) only have minimal criteia to filer by to begin with. Column D on the other hand...

Hello! I would greatly appreciate assistance in finding a solution in the excel ribbon or a VBA Code to automate the following task. I am creating a spreadsheet that is a download of all purchases that I have made for my music store since opening 6 years ago. Each row represents 1 item on a...

Hello, I have a pivot table that currently shows the following: <tbody> Column Labels EXPIRED COMING UP TO EXPIRATION Row Labels Count of Item Code Sum of Total Value Count of Item Code Sum of Total Value Tables 74 $817,008 27 $68,000 Chairs 3 $422 19 $900,000 Books 18...

I've been struggling with a formulae (having tried various connotations of COUNTIFS) to first: - count the number of matches per item (an item can occur multiple times in the Master list) on an extensive list but that is further restricted to only those whose characteristic of interest has to...

hi, guys i'd like code works to consodilate data from multible sheets to one sheet i have sheets1,2,3,4,5 the data columns a,b,c,d in all sheets what i would be showing data in sheet5 but the column d contains brand is formula like this sheets5=(sheet1+sheet2+sheet4)-sheet3 and...

I am creating an order form that allows users to select items from a drop down. I want a pop up to show up when they order the same item more than once. I have the following formula for the Data Validation (list) for the drop down...

I am attempting to create a form in Excel for our sales to to request quotes to our office. I currently have a list of products in a drop down and each of those items require additional cells to be completed. Is it possible to create an if/then from a drop down that would unhide the additional...

Hi, I am a creating an inventory database with about 100+ items. I am using a userform to select the ITEM PART via combobox, PO# via textbox and QUANTITY via textbox then enter it into my inventory database. What I would like it to do is search for the item number that was selected in the...

Hello, I am wondering if anyone can please suggest a way to automatically run a macro, each time an item in a slicer is selected. Currently, I'm using a button that needs to be clicked to run the macro. The problem is the button needs to be clicked each time, after selecting the item in the...

I have two named Tables detailing price proposals from mfrs on different dates I want to merge these into a single table detailing the minimum cost and associated detail per Item <colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody> Item Mfr MPN Cost 10001...

Hello all, I was wondering if it is possible to create an if statement that does different things depending on how many decimal places appear in a number? For example if I have the numbers 27.23 and 30.496 can I do an if statement that multiples 27.23 by 4, but multiplies 30.496 by 5? What I...

Hi Everyone, I'm using this formula to get item name from another excel file when I enter the item code. Am wondering if it's possible to search in 2 files and retrieve the item name. Item code will be in any of the following file. Product Master.xlsx or Archive Product Master.xlsx...

Hi there, I have a sales sheet that I use VLOOKUP for to return an item value for SKU which met my needs until now. The problem that I have is that the current VLOOKUP formula that I have at present will only work out the value of one item as it only references the SKU and performs the VLOOKUP...

Hi I have a dynamic field for get total in my working sheet, Total column is same but row can be variable depending on description include Example cart is here <tbody> S.No Description Code Country Ctn Qty Price Amount VAT % VAT Amount Total Amount Gross Weight (Kgs) Net Weight (Kgs) 1...

I have an Excel formula that I put together to consolidate the content of a whole grid of cells into minimally formatted bullet lists. However I have had to cut it off before the character limit. What I am doing is taking data exploded into discrete elements and pulling it into a cell, to...

Hi - I have in A some order numbers and D has dates. A will populate blanks below row 1 until a new order begins and then enter a new order number followed by blanks dependent on how many lines on the order. D has 2 different dates. I want to be able auto fill the blanks in A (already solved)...

Hi - I have in A some order numbers and D has dates. A will populate blanks below row 1 until a new order begins and then enter a new order number followed by blanks dependent on how many lines on the order. D has 2 different dates. I want to be able auto fill the blanks in A (already solved)...

Hi guys! I'm not sure if the excelforum website is also part of this forum or not, but I posted a question there and I'm gonna post it here as well because I'm a little short on time. Thanks for any help you guys can give. I'm not great with VBA but I found this article that can help quite a...

Hello everyone, I'm attempting to search through Outlook to find an attachment that is given a unique name with a date. However, there is part of the filename that is the same all of the time. I'm receiving the error on the line where I'm setting the sPath. I've got other code, that should be...