inventory

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

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

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

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

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 = "\\172.27.154.13\D$\Excel Dashboard\Inventory" If Right(strPath...

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

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

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

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

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

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

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

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

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

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

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

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

Trying to minimize leftovers to be as close as possible to 0 but not negative by shifting inventories around Inventory qty can only move horizontally (i.e., Inventory 1 can't move to inventory 2 or 3) Inventory qty is already given, each qty is treated as a whole and can't be combined or merged...

To simplify here is what I'm trying to do From this: To this: Move inventory 1 to 5 to the next month and ensure that leftovers is as close as possible to 0 but not go negative. The inventory Qty is treated as a whole and can't be combined Previous month's inventory takes priority and it can...

Okay excel genius', I'm stuck in a rut and need your help! I work at a shop that carries a stock of liquids. It is my job to keep track of the inventory on a daily basis. If this was my only job, then it would be easy, but its not. So, I began working on an Excel file that could automate the...