item

  1. V

    Download Attachments from outlook

    I just want to give a path to download the attachments, but no success, It is now a hell of the code. is always opening the browser folder which should not be the case. it should directly download the attachments in strPath. "strPath" its not working, Code strPath =...
  2. R

    Simple Scanned Inventory in Excel

    Hi, If this isn't appropriate, please forgive me and let me know. I have a small business and am looking for a simple solution to taking inventory at the end of my season. I would like to be able to scan barcodes to enter the info. I would also like to be able to scan an item 3 times, for...
  3. H

    Sum 2-dimension array

    Hi Everyone I have the excel file to control storage as attached link. The Sheet1 is an storage, and sheet2 contains goods which I want to take out.... I want to compare the quantity at Sheet2 with quantity at Sheet1 of item "Apple" with code is "AP" base on the current date&time and Expire...
  4. B

    Sorting Across the Down with Photos

    I'm creating a database of sorts with Excel. They want a photo page with links to a details page for each item. I'm trying to make a sheet that is 10 columns wide and then raps to the next row. The links are tied to the images so they need to be sortable in the case that a new item is added. I...
  5. N

    Search manually from sub_Change

    Hello, I have a userform with a lot of textboxes, one of these textboxes is "txtBarCode" that allows me to enter any Barcode to check if the item is exist or not and lookup values for "txtItemName" & "txtPrice" and I have the code below that works very well But, sometimes I need to enter the...
  6. N

    Userform Textboxes values passing to a listbox

    Hello, Please I need your help. I have the link below for my shop workbook "example workbook" that contains a userform to manage my invoices I'm stuck in the following steps and don't know how to solve them, and need your help if you may In TextBox "txtBarCode", If I search for an item by...
  7. 2

    Home inventory cell pop-up

    Hi there, i made a small parts list. In column A 1-99 each cell will have an item. Ex. A1 saw, A2 hammer, A3 screwdriver. When i click on an item such as A1, I would like a form with labels and text boxes to pop-up. i know i can make a form that matches my headers but i would like certain things...
  8. VBE313

    Udf vlookup

    I have a table of items that are assigned a fixed cost. Example: Item) Name) Price 1) Red Ruby Shirt) $35.22 2) Blue Tuxedo) $47.90 On a separate sheet I have a UserForm with a list box that grabs the table from the other sheet. I would like...
  9. K

    Sumif/sumproduct help!

    I am struggling with creating a formula that works for the below scenario <tbody> A B C 1 Item Budget v1 Budget v2 2 Item A 50 55 3 Item B 60 65 4 Item C 70 75 5 Item D 80 85 </tbody> I have two sheets in one workbook. One with full budget data with in this scenario a Budget v1...
  10. 2

    Parts lists pop-up

    Hi there, i made a small parts list. In column A 1-99 each cell will have an item. Ex. A1 saw, A2 hammer, A3 screwdriver. When i click on an item such as A1, I would like a form with labels and text boxes to pop-up. i know i can make a form that matches my headers but i would like certain...
  11. J

    Create poup on item in home inventory

    Hi there, I created an home inventory in excel. I would like a popup to display information about the item when i click on it. I know Microsoft access has a home inventory and when an item is clicked on an asset detail popup is created. Just wondering if i'm able to copy this form to excel or...
  12. C

    Lookup and Replace From Another Sheet

    Last week, Akuini gave me an awesome script that I was able to use for one of my worksheets. :) I tried to expand on this to account for another scenario I needed to cover for a different sheet in the same workbook, but unfortunately, my lack of Excel skills is knocking me down again. When I...
  13. K

    SUMIFS Question

    Hello, I have a table that contains 5 different groups of items. Each of those items have a price, on a separate reference table. I am trying to determine the total price of each group using a formula. <tbody> A B C D E 1 ITEM 1 ITEM 2 ITEM 3 ITEM 4 TOTAL PRICE 2 apple...
  14. S

    Excel VBA Find based upon multiple criteria

    I have some code, that when run from the current workbook (a template), it opens a different predetermined workbook (Sales Log), performs a find in column "A" in the Sale Log to determine the corresponding row of the item # from the template, and places certain results in the Sales Log in that...
  15. M

    Listbox click event

    Hi, hope someone can help with this. I have listbox1 that has multiple items. I would like to select an item by double clicking the selected item and open a file. I have the path of where the file is so just need the code when double clicking the selection. thanks
  16. S

    Help with how to get the data please

    Good Morning, I have two spreadsheets: 1. Is a master file of 10,000 cutomers that contains all information such as name, ID, address, payment schedule, price charged, item brought 2. Is a file that has some information in, but has lots of missing data. I want to use file 1 to populate file 2...
  17. C

    Replace Value with Next if Zero

    I have an Excel question that I am afraid is out of my range of expertise. I have a list of items with inventory values. What I need is either a formula or script that will say if the value is zero, then grab the value from the next line for the same item number if it is not zero, and continue...
  18. F

    Dictionary - defining range

    Hi I would like to add a list of items to a dictionary and then loop each item. The problem is, I don't know how to refer to a list range that is on another worksheet than the main data that is being filtered. "Items" are located on sheet wsList, so where am I suppose to add it? Dim dict As...
  19. N

    Adding Data from an Excel Form

    Hello, Please I need your help with my project. I have made a system for my business and need to add some forms using different tools and entry methods The form contains: Text Box Combo Box Option Buttons Check Box Commend Button Once I open the form to add a new Item... 1- TextBox1...
  20. V

    Complicated Project

    I'm new to VBA and so far i've mostly copied other macros and adjusted them to my needs. So i don't fully understand the language. I deal with A LOT of data at work, usually a table with thousands of rows of data, and about a dozen columns. I always have to filter the data on a specific item...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top