1. M

    Help with creating an inventory management for production purpose

    Hello! I work with manufacturing security doors, and to make my life easier I wanted to create an excel chart with a table of materials in the inventory then subtract from them the materials I need for each type of door I am going to make. For example, let us say I made door1 and it requires X...
  2. I

    Raising or discounting the price of inventory against a curve that represents the average temperature in a certain area.

    Hi all. Firstly im new here and English isnt my native tongue so I would like to apologize beforehand if my explanations aren't very clear. Truly appreciate if anyone can help me with the following: I generally have two sets of data: 1.First one is an inventory list of clothes with their...
  3. G

    Excel/Sheets - ISO Solution

    Hello all, I'm trying to improve the inventory management process at work, currently we're tracking everything through manual input (handwritten) using a form and then we put any relevant information on a sticky note and post it to the box. These boxes come in from numerous different places and...
  4. C

    Inventory Add-On

    I've looked around here but couldn't find what I was looking for. I have a client who does inventory audits. He gets an inventory list in Excel the night before his count from the warehouse manager. These lists are formatted in all kinds of crazy ways so that night we reformat the list...
  5. C

    Clueless, inventory quick search

    i started using excel at my current new employment. I got to say that i am quickly become a little obsessed in learning more! Right now i am creating an inventory list with shelves named by alphabet and number of shelves. ex: A1,A2,A3 and so on. Every letter has its own tab, containing the...
  6. V

    Batch Inventory in excel

    Hi, can any one help me with my office batch inventory solution in excel. Dispatch data is available and i need to summarize it in batch summary. Thanks a Lot.
  7. L

    Change Formula

    Hello, I have the below listed formula that was created here for me, but I need to change it from looking at H8 or D8 to just look at the whole column for example just H or D and if it find it copy the date were it matches =IF(IFERROR(INDEX('Inventory Stats'!$H$8:$H$100,MATCH(D8,'Inventory...
  8. K

    How do I take a total value and reduce the value of a cell and move to next until the total is met?

    It's difficult to describe, but could be considered something like a first in first out calculator. There must be an easier way to do this than manual subtraction. For this example the total inventory is 7500, I Would like to find how much was under 25, and if the total isn't met then move to...
  9. S

    How to get excel to accept input from a barcode scanner and add "+1" to a column

    Hey friends. Not sure if this can be done but here is what I want to accomplish. Our store's inventory will happen soon. Our old style of doing inventory is slow and I want to streamline this process. Our point of sale system allows me to export all of our inventory items, which includes the...
  10. L

    Automatic counter based on changes to a cell (inventory usage tracking)

    I am a librarian interested in tracking book checkouts over time. I only need to track how often an item has been used, not when or by whom it was used. My library is too small to justify the purchase of an ILS (circulation software), so I am looking for a simpler solution using what I already...
  11. 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...
  12. 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...
  13. A

    Dynamically Pulling Data between Worksheets

    Hello, I am trying to do a small pull of data between two worksheets but in an active manner, I'm hoping someone here might be able to figure this one out as I can't come up with a perfect solution. Sample Data on Worksheet1: On Worksheet2 I would like to pull anything that says 'Yes' in...
  14. I

    VBA to open a PDF in another location.

    Hi All I have the following code that searches a network folder for a PDF doc based on the number in a cell and opens it if one exists: Sub OpenPDF_3() Dim strPath As String Dim strFileName As String strPath = "\\\D$\Excel Dashboard\Inventory" If Right(strPath...
  15. Vincent Thank You

    If cell above it contains same data, change formula

    I've been stuck on this for about a week, I'll do my best to explain what I'm trying to do. I have column J with the following formula: =(((G2)+(F2/Q2))-(NETWORKDAYS(TODAY(), I2)/22)) I'm using this formula to tell, based on months of inventory on hand (G2), plus months on purchase order...
  16. H

    VBA List Data

    Hi all, I have a list of data: Apple 580 Pear 245 Orange 867 Cherry 870 etc. What I want to do is split my inventory between 5 locations randomly, but will only ever total the total inventory and then have VBA print the array so that it's like the following: Apple 156 Apple 142 Apple 52...
  17. J

    VBL copy paste to new worksheet

    I want to copy and paste a row to a new sheet when a cell in that row contains a certain text string (not the whole cell value as shown in code below). How do I modify this code so that it finds any row that contains the string? Also, if you could edit this so that it never appends the rows to...
  18. M

    New to VBA: Go to Next If Statement

    I have some code that I am messing with for a pet project at work for an inventory form. I have the pictures of an item with macros for a mouse click to remove one from the "on hand" inventory. in Sheet 1. From there, I have on Sheet 2 the "inventory database" which includes the Quantity on...
  19. D

    VBA adding multiple attachments based on record count

    I have posted some previous questions concerning this matter, but I don't think I clearly explained what I'm dealing with. So I am creating a new post in the hopes I can clear things up. I have an issue with some code that I have to create a generic email and add an attachment to the email. I...
  20. M

    Selecting Data to be emailed in VBA code based on cell color

    Please forgive not asking the right questions, but I have created a basic inventory form that I have triggered to email be based on a cell color being = to 255(red). I have column (A) conditionally formatted to fill red when the Inventory(D) drops below the Reorder point(C). As each line item...

Watch MrExcel Video

This Week's Hot Topics

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
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 "".
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