1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. D

    Sending multiple emails based on Store number

    I'm attempting to modify some previous code I wrote which would send out an email to the email address listed in the column next to the specified value. The value was "EXPIRED", however, what I'm trying to do now is basically send out one email within the active report without sending multiple...
  16. R

    Adjusting stock data on stock usage spreadsheet

    Hello All I am trying to automate a task that is completed every day on a spreadsheet. I have an inventory tab, which contains the stock details of some 1200 different products. Each day we consume some of these products and update the inventory sheet using the find function and manually...
  17. B

    barcode and description

    hi im scanning barcodes into A column and want b column to put description of item in column in B I am trying to create a inventory sign out, sign in page for search and rescue Thanks Barry
  18. D

    Formula help to create Inventory

    I'm working on an inventory sheet that pulls from received items on Sheet #2 . I have a couple of cells that contain variable (items) and I want to know if there's a way to have them added or subtracted from sheet 2 totals. Explained: sheet1, B7 contains either "shipped" or "returned". G13...
  19. K

    Sequence filling of table for order picking based on current inventory

    Hi all, I am trying to find the best way to fill up a dynamic table with the right values as easily as possible (hopefully one click) once I input the the order number and it's details. I am stumped not sure whether I'll need to use helper columns / vba. I wanted to get the answers to the "To...
  20. C

    Copy cell value across number of columns based upon cell value

    Good morning all, I'm trying to develop an inventory reduction forecast spreadsheet in a pivot table format for ease of use - but am really stuck with 1 part to add in the data. What I want to do is copy a cell value that is calculated (weekly forecast inventory reduction),across a number of...

Some videos you may like

This Week's Hot Topics