Attempting To Create Inventory List....
Mar 4, 2008
(Excel 2007)
What I'm trying to create is a way to populate a quick inventory list with my bar-code scanner.
I've already learned that in order to have excel move to the next row each time a 12-digit SKU number is scanned, I'm going to have to utilize a userform text box.
My problem:
I don't even know how to begin coding the text box to accept a 12digit number, enter it into the next available blank cell (I'd like it to populate vertically) and then ready itself to accept the next available 12digit number.
My desired end-result:
My scanner is attached to a lengthy USB-Extension, so I can roam my store and quickly scan the inventory on display. For that reason, running back to my laptop and striking "Enter" each time makes the whole solution pretty useless.
Once finished, I'm assuming I could use excels count feature to tell me the quantity of the items I have on hand.
View 9 Replies
ADVERTISEMENT
Aug 8, 2006
I am not an excel whiz, so I will need layman's terms if possible. I may have found a solution to my problem under another thread, but I couldn't understand it. I have only briefly worked with macros, a very long time ago. Here goes...
I have an inventory list that has not been updated for sales of the inventory, only for purchases. I have sales lists, generally by month, in separate spreadsheets. I am looking for a simple, efficient way of either eliminating or at least matching up the data in the sales list to the inventory list in order to remove sold items from inventory (on paper). I am hoping the result will be a fairly accurate inventory list, and related value, so that a physical inventory count won't be necessary at this time. Obviously I could copy all of the sales info into one spreadsheet, sort by inventory number, then manually delete all sold items from the inventory listing. I am REALLY hoping there is a better option.
View 6 Replies
View Related
Mar 17, 2014
I am looking for a Macro that would randomly select 20 items from my inventory list for performing spot checks. Column F of Active Coil Log tab is where the data would need to pull from, however I would like all data in the row to go along with it. I've explored the RAND functions, but they don't seem to be the right fit .
View 2 Replies
View Related
May 10, 2014
I am trying to create a Macro that will let me copy and paste the Inventory with the Corresponding SKU on a different spreadsheet, I have attached the Spreadsheet, Sheet 1 is the Missing Quantities and Sheet 2 has the updated Quantities that will need to be identified by SKU from Sheet 1 to Sheet 2.
View 1 Replies
View Related
May 24, 2014
Im trying to organize a tools inventory list. Its supposed to be sort of like an order sheet for each department. But what I want to do is when I select either CARPENTRY, or any of the other trades from a drop-down list, I'll be able to select from another drop-down list items associated with that trade in particular. So eventually I want the master data hidden, preferably in another sheet. I searched all of Google but it seems a bit complicated to get it done. I've attached the sheet so that you can see what I'm talking about. MOVE IN MASTER LIST.xlsx
View 8 Replies
View Related
Aug 22, 2009
I am trying to make a tally sheet to keep track of my inventory of inserts. I am trying to make it as user friendly as possible as my operators do not have much experience working with computers. I will attach what I have made so far. The only math functions so far are: C4=B15-C15.
Right now the operator has to look at C4 to see current total, type that number into B15, then in C15 type the number of inserts thrown out to show a new current inventory total in C4. Is there a way I can set this up so that all an operator has to do is type in only the number of inserts thrown out in C15 to give current total in C4. Is there a way to make B15 know what is in C4 without the operator having to type it in. If so is there also a way to make C15 the only cell that can be edited.
View 3 Replies
View Related
Sep 28, 2009
I'm trying to make a simple program to allow me to total the amount of air filters I need to purchase for a given month. I am entering the amount of filters for each property and the frequency of replacement ie. monthly, quarterly, one month out of the year, etc. I would like to enter a month, ie. 2 for february and have the program list the quanty of each filter that I need to purchase for the given month. See sample attachment.
View 3 Replies
View Related
Jul 9, 2014
I created the following macro by recording the macro and going through the steps manually, however I need to make some changes and can't seem to accomplish what I'm trying to do.
The Macro opens a master inventory file, creates a new line, and then links certain column cells in the inventory to corresponding places within the original form (the macro is executed from the original form once it's completed).
Problem is, the macro is written using the form "template" so whenever I save the template as the name of the unique item, it won't update the macro language as well.
What I'm trying to accomplish is when someone opens the template, the save immediately with a different file name, and once the form is completed and the macro is run, it's creating the new line in the inventory pointing to that specific file.
I thought somehow utilizing ThisWorkbook within the macro instead of explicitly using something like
"='[Control Sheets (JOHN TEST).xls]FUND SET_UP PG_1'!R2C3" would accomplish what I'm trying to do.
View 5 Replies
View Related
Sep 10, 2012
How do I print multiple inventory labels based on our inventory levels?
For example:
Item No 1000
Descr Window
Customer Taylor
PO 9001
Quantity 10
Item No 1010
Descr Door
Customer Jones
PO 9011
Quantity 35
I want to print 10 labels with the info from Item No 1000 and 35 labels from Item No 1010????
View 8 Replies
View Related
Jan 20, 2012
i am brand new to this forum, and not so fluent in excel for more complicated tasks.
i have been looking for a solution for this online, but seem to be running in circles, so thought i would post here.
I want to make an shipping list using a barcode scanner. i have a master list that contains all of the inventory numbers and the relevant item data in each row. i would like to be able to scan the barcode of the item and have excel automatically look up the row from the master list and put it into the shipping list.
View 5 Replies
View Related
Mar 28, 2014
I've got a long list of inventory items. The naming convention of these items is not totally consistent. Below is a representative sample of all the different kinds of names:
1800Brandacom (CLIENTA) 25.00
1800Brandacom 25.00
brandb (Variable)
BrandC-100.00-PL-ALG
brandd variable
[Code] .....
I need to separate out the name of the brand and the number (or if the item says "variable", use a 1 for the number) into two columns, so that the results would be:
1800Brandacom
1800Brandacom
brandb
BrandC
brandd
[Code] ....
and:
25.00
25.00
1.00
100.00
1.00
[Code] ....
For the numbers, I have used this array formula to search for the first letter in the string, and then search for the first number following the first letter, and then return all numbers up to "." Unfortunately this does not work consistently when there is a number in the middle of the brand name or the item has no number.
[Code] ....
For the names I have used this formula, which fails when the name has a "-" in it.
[Code] .....
Any way to extract the names and numbers which would work consistently across all the items!
View 4 Replies
View Related
Aug 18, 2009
I had been trying really hard to get some solution on COGS valuation & inventory valuation on FIFO basis. my daily transactions are typical sales & purchases.
Attached is the inventory in/out movement from Quick Books. in the column "Num" type bill is the entry from purchase bill whihc always has a reference as P/O####. This is how i will capture the landed cost against a PO., another type "Inv Adj" is inter warehouse transfer. Name is cusotmer, Inventory is my item number. in some cases it is like "2000", in some cases it is 10000:10121, and in some cases it is 10000:10200:10201 that is why they fall in different columns when i export them.
What I would lilke to do: 1) Run a report by month, by customer showing cost of goods sold on FIFO basis, I can capture sales amount by running another report.
View 11 Replies
View Related
Feb 27, 2007
I have a workbook. The second tab is inventory numbers and the first tab has my inventory items. I scan in the inventory number (unique) and it adds it to my inventory sheet. As I use inventory I scan the barcode and it inputs the serial number into my used inventory tab. What I need to do it when I scan the serial number for used inventory into the used inventory sheet to have it go to the inventory sheet and delete the line for that serial number.
View 9 Replies
View Related
Feb 1, 2008
I'm currently trying to sum across a row only if certain text is present. So, if A1 has CT8 and A2 has 5 and A3 has CT5, I want to just sum the cells with CT in them. I've already worked out how to strip the CT from the numbers in the sum, but not how to specifically only sum if CT is present. And of course, the sheet uses other letter/number combinations that need to be separately summed.
View 9 Replies
View Related
Apr 14, 2014
I have been attempting to copy a date & time with a specific format from one sheet to another and add " before and after it in the same field. This is being done to create a specific csv format for date.
The Formula I am using on sheet3 is - =IF(Sheet1!A3="","",Sheet2!I3&Sheet1!G3&Sheet2!I3)
The Values I am using are below
Sheet1!G3 Format = yyyy-mm-dd hh:mm:ss
Sheet1!G3 = 2014-02-11 07:00:00
Sheet2!I3 = "
Formula Results = "40219.2916666667"
Intended Formula Results = "2014-02-11 07:00:00"
I have used a similar formula for other fields within the xlsx, and the only one I am having issues is with the date field. It keeps converting to a serial number when the calculation occurs and the copy and formatting occurs. Formula to get it to come out with the intended results?
View 5 Replies
View Related
Jan 9, 2009
Had a bit of code I was working on for a guy on here, and came across a problem while putting the finishing touches on it. It's since been solved by someone else, but for future reference...
View 13 Replies
View Related
Sep 7, 2008
I am attempting to match data entered into two cells. The data input goes into Worksheet 1. In Column A Row 1 the user inputs data... Example: 5. Then in Column B Row 1 the user inputs separate data... Example: B. I would like the result returned to Column C Row 1. The lookup would be on a table in Worksheet 2.
Worksheet 2
A B C D E F G H I J K L M N O P
1 2 3 4 5 6 7 8
A Pig A Cat A Dog A Fish A Ox A Bat A Six A Pie
B Pie B Six B Bat B Ox B Fish B Dog B Cat B Pig
C Fish C Ox C Cat C Six C Dog C Pie C Pig C Bat
Therefore the Entry 5, then the entry B would Return: Fish
So it's a lookup and match Column A-P. Then using that match lookup Row 2-4 for the second match. Then Return the data from the cell next to it.
View 9 Replies
View Related
Jan 8, 2013
I have recorded 7 different macros and then combined them all into one macro to achieve one end result. I am not sure if you can just look at the codes to determine different ways to improve them or if you need the excel spreadsheet as well.
View 2 Replies
View Related
Jun 13, 2014
I"m attempting to generate a report to show the number of occurrences for a particular product within a calendar month.
Data is stored on the first sheet, output is populated on a separate sheet. Seems simple enough, but getting the "month" out of the date, whilst referring to another sheet seems to be the sticking point.
2014/03/24 14:34:17
Product1
2014/03/24 13:45:51
Product2
[Code]....
View 7 Replies
View Related
Apr 18, 2014
Basically it is another sports modelling experiment that I have had (I get the day off work and come up with things like this ), where I just had a curiosity to play out the last games for the top 3 teams in the English Premier League (just to see if I could get some percentages).
The attached, is just the values from one run of my model (I have taken the workings out to reduce the size and for other reasons).
Basically everything to the left of column K, is the model and I am happy with it (and I know goals have to be integers - this is basic);
This plays the games out, and feeds the data into the table at M36 (highlighted yellow), which feeds the data tables at M42 (highlighted green), which are counted to get percentages in the tables (highlighted yellow at M6).
I have put some example output from runs on the second worksheet (so you can see how it works - I like that it suggests Chelsea can win even though it won't be very likely )
Basically you can probably see the problem in cell O22. The percentage chance of finishing first should equal 100% when totalled (e.g. the sum of Liverpool, Chelsea and Man City finishing first, as it has to be one of them should equal 100%). I tracked this back to the fact that I had no way of splitting teams level on points. As a result I added Goal Difference to the model (crudely - e.g. decimal) and here's the question;
How would I go about using Goal Difference to break tie's effectively?
I am thinking I could do some kind of IF function in Q37 (and then have a tie-breaked rank in column R to feed the data tables), on the basis of if anything in N37 to N39 was equal but I am not sure how I would go about applying this.
Example Values_EPL.xlsx
View 10 Replies
View Related
Oct 28, 2013
copy or cut then paste - paste grayed out in excel 07 tried several popular fixes from the web without luck.
Tried: the Excel repair and diagnose tool
Tried: uninstall / reinstall Excel program as well
Tried: go into Hikey - user - software - Microsoft - excel - new - 32 binary and tried adding new rule
Tried: Close Excel.2. Go to C:Documents and Settings[userID]Application DataMicrosoftExcel3. Delete the XLB file.4. Open Excel (the XLB file will be recreated - like the normal.dot) ------> This one - I could not find the XLB file - looked everywhere.
Tried: Open excel hit alt-f11 (to get to the VBE) hit ctrl-g (to see the immediate window) type this and hit enter: application .command bars ("cell").reset Then back to excel to test it."
View 3 Replies
View Related
May 17, 2013
i have many excel workbooks in a folder i want a macro that will get the names of all the files and make the file names so extracted as a hyperlink to open the files.
View 1 Replies
View Related
Nov 21, 2013
I'm trying to create a staff rota which will populate a rota randomly when prompted - I have been trying to find some way of connecting the random lists and the staff names, though this has proved difficult (to say the least!). How best to proceed? I'm also fully aware of the possibility that my present design will also double book people (place then on reception and telephone duty simultaneously).
View 3 Replies
View Related
Feb 25, 2014
Is it posible and how to create a list of barcodes from a list of numbers on the worksheet?
Strokescribe seems to have some ind of solution but the data can't come from the worksheet.
View 8 Replies
View Related
May 23, 2009
I've searched the forum and believe this thread to be the closest to what im looking for, but its doesnt completely apply: matrix to list conversion. I have an attachment to support my questions (see attached). I have a matrix of words (strings) that contain repeating and non-repeating contents. The matrix also has spaces which are of no value. Essentially, the VBA needs to ' analyze' this matrix and create a consolidated frequency list (as shown in the file).
The matrices are HUGE and therefore some of the clumsy VBA i am using is turning out to be a bit inefficient. The file also contains formulas and such that I cannot use AutoFilter nor can I use Insert or Delete rows...so the VBA shouldnt use those either.
View 6 Replies
View Related
May 27, 2014
Eng list.xlsx
The attached file (a copy of my main one) has a list of our engineers, and what stock they carry. The stock parts are the 64, 65, 66... numbers.
I need to create a list from this (as underneath the main table), for all instances where there is a 'Y' in the columns next to each engineer. So if an engineer has 3x pieces of stock, they need to appear in the list 3x times. If they have 1x piece of stock, they appear in the list once.
View 8 Replies
View Related
Mar 17, 2007
I Attached a sheet for what i'm asking about ,, i sent it before but the sheet showing it more clearly
View 10 Replies
View Related
Jan 4, 2013
I've attached a spreadsheet showing the effect I'm trying to achieve. A list (which changes weekly) contains employee details and length of service. Based on the length of service I need to build a new list grouping the employees based on the service length.
list-test.xlsx
View 6 Replies
View Related
Feb 6, 2014
I am looking for a formula to search two columns.
1) The first column needs to be search to match a text string.
2) If the text string matchs, I need excel to evaluate the number in the second column and find the MIN value of all numbers associated with the text string.
So:
Joe 50
Jim 12
Joe 10
Rob 25
Jim 8
Rob 99
When searching for "Joe", the function would return 10. When searching for "Jim" the function would return 8. For "Rob", it would return "25".
View 4 Replies
View Related
Apr 5, 2014
I need to create a mailing list for people located in a specific area from a master list.
The address data is not in great shape so I need to check address field 2 and address field 3 in the list to see if the suburb in the location tab appears in either of the two fields.
Desired result appears in column F of the List tab of the attached spreadsheet.
seminar addresses.xlsx
View 2 Replies
View Related
