parts

So this code does what I want it to (mostly) the only thing that is missing is a way to move onto the next line down in the program. This sub right now, finds and pulls the row in "Parts Master" after inputting the part number in ("D6") on "Monday" and puts the data in Row "A" on "Parts Order...

Hi everyone it is my first thread on this site I am stuck with an issue and I hope you can help here is the file attached basically it's about stocking products between 3 warehouses. warehouse1 warehouse2 warehouse3 stock of 42 references each warehouse contains rooms in which there must...

Boy do I have a dooze!!! lol, I am having trouble figuring this out and would love some help! :) SO I have this code that I was using that you would put a number in a cell on sheet 1, it would pull the data from sheet 2, and put it int he cells I had set with offest. Now i would like to do the...

Hey guys, It has been a little while since I have posted so I hope you all are doing well! Anyways I have been given a project and I am looking for ideas getting started. I am not sure excel will be able to handle the project I have been given. Should I use Access? Or a program I am unaware...

I am trying to create a worksheet for my students. Decomposing a number written in standard form To its individual parts. Example in A1 cell I will randomly generate a number into the hundred million. In B1 I want it to shown the parts of that number. Example In A1: 904,004,350 In B1 I need it...

Hello, I am trying to make some graph with this data but unfortunately my knowledge is not enough. I want to show to my team the evolution of the defective parts through the years, when I try to put in the graphs the large numbers hide the small numbers. Any idea haw could I make this graph in...

Hi I want to set up a general general RFQ compiler using Excel. I would start with a table and manually input part numbers. Then I would use a macro to input suppliers and prices. There could be 20 parts in total but some suppliers might only be quoting for 1 or 2. I am thinking of using...

Hello wonderfully smart people! Can someone help or point me in the right direction... I would like to have a list of tasks, say A2:D15 would be a list of things to do. Then F:J would be days of the week. So, for example, A2 is "Inventory Parts" and H7 is "Inventory Parts". As H7 is filled...

Hi all, I now have two worksheets, one containing usage of materials of a product. (Part no. in column A and usage in column B) The other worksheet I have contains purchase price of materials (Part no in column A and price in column B) I tried to use the sumproduction function to calculate...

Hi, On a Worksheet_Activate event I am looking for a way to copy all items found in a range $C$4:$I$100 (I'll name the range "Parts") to a different worksheet "Part Text", ignoring blanks and duplicates. I would like all items found in the range copied (ignoring blanks and duplicates that may...

Good day, I am stumped once again and I'd like to know if someone could share some incite to the realm of possibility. I need to look up a part # based on a completely different number. However my "part #'s" have process codes at the end. For example - part # 12-4567*05S goes with part...

I have the following tick boxes: "New" in Cell B18, "Used" in C18 and "Refurbished" in D18. I have a "Make" which would just be text entered i.e. "Mitsubishi", "Toyota" etc in B22. If the "New" checkbox is ticked in B18 and a Make is entered into B22, I want it to do a VLOOKUP to my...

Morning, I am using a userform for data entry to a worksheet. Currently say Combobox5 is for a certain car part. In the properties of Combobox5 under RowSource i have INFO!T2:T68 of which is where these specific parts are listed. My question is When i add more car parts to the list, so now my...

Hey everyone. I have been working two days on trying to figure this out and have made no progress. I've read the multiple posts and numerous other websites, but cannot get it to work. So below I will explain what I have. Dim lastFriday, Sunday, Monday as date 6 columns: actual release, actual...

Hello, I am a excel dummy and learning as I need to something different. I looked but didn't see a topic for what I am wanting to do now. At work we have a Good Parts room where we take parts from when we do a repair. Currently there is a form that we are to fill out when we take parts but most...

I have a “Master Parts List” sheet where Part Numbers start in A2 and Part Description starting in B2. I have ~ 25 Sheets each with a different name where there are columns in each. I want to match the Part Number & Description to the Master Part List and sum the total Quantity of parts from...

I have a list of data that that has two options: "Vendor" and "SearchTerm" As of right now my data looks like this: Column A Column B <colgroup><col><col></colgroup><tbody> Vendor 1000056 SearchTerm MACHINE PARTS Vendor 1000059 SearchTerm MACHINE PARTS Vendor 1000065...

(Excel 2016) I have a row of cells that 'vlookup' values from another workbook. I want to conditionally format cells that have a minus value, the same as I have in other parts of the sheet. However, I cannot get these particular cells to format. I'm obviously missing something. Any help would be...

I basically created two excel sheets. One with parts + price and another with a master sheet for components and price, basically on the parts sheet there are about 3000 line items of parts containing two components each. I need a foruma that will grab the price data from the component master...

Please help if you can So in column "A1" I have a part number like 12345 and in "A2" I have a number 12345C. It goes on like this for 10,000 lines. Column "B" has prices. I need the prices on the same line. I could do this using Vlookup if I could move just he parts with "C" at the end to...