parts

Hello, I have 2 sheets. Sheet 1: Sheet 2: Part # Description Weight Part # Description Price a xxxxx 2 b xxxxx 1.00 b xxxxx...

Hi all, So I have a very large spreadsheet which contains all of our parts and part descriptions. It was merge between old data and new data. I am needing to see which part's descriptions have change from then and now. When B is a match (part number), compare D (Description) and write match...

Trying to get and set an image's scaleheight and width msgbox activesheet.Shapes(1).ScaleHeight returns nothing. I realize there are 3 parts to Scaleheight and width Help a brother out? Thanks

Hi I've created a spreadsheet to record VAT returns for a small computer repair business in Ireland. I like to tweak it to make it run smoother and faster - it has a selection of if statements working well but the macros are proving too difficult to implement. There are two applicable VAT...

Can someone please help me fix my formula, Im trying to make it dynamic by using two variables "loanNumber" and "Name". All the other parts are named Cells / ranges. Cells(Rows.Count, 6).End(xlUp).Offset(1, 0).Select ActiveCell.Formula = _...

Hello all, I am looking for some advice on how to set up a formula to allow me enter student marks for answering parts of a question The question 3 parts (each part of the question has 5 marks each) and a student may answer any two parts. their marks are capped 10 marks so the maximum that can...

Hello, I have a giant order spreadsheet where I need to continuously filter roughly 100 parts from 1000 possible parts in a column from a table. I tried VBA criteria code but there is just no way it goes through all 100. All orders are placed in sheet : "ORDERS" and i want the parts I need...

Shortly: I need the range of A1:B3, then A3:B5 then A5:b7 _______________________________ Parts of my thoughts, but it leads nowhere because I can't make a code from it, these are just parts of it, but I can't combine them in the right way: So I have 2 variables: Dim i as integer dim j as...

Hello, I am trying to create a macro that will remove spaces from a column, IF it starts with "3 464 xxx xxx". Our vendor has spaces in their part numbers, but our system does not use them. Externally, we have to keep the spaces, but for internal use I need to remove those spaces. I have...

I have imported some data using VBA in an excel file. I have a 100's of parts numbers in column A and corresponding 6 numerical values for each part in column C. (For example, if "A5" has part number then data would be in "C5:C10"). I also have a numerical criteria set in another cell "B2". I...

Hello, I have a program used to estimate the cost of and then design large machinery. First, an estimator will enter the specifics needed for the machinery and select all the parts for its construction (motors, steel, etc.). This is all tallied up on a worksheet, "Selected Parts", and a cost is...

Before I go into any detail I want to post a high-level summary of what I am attempting to achieve to see if it can be achieved. OVERALL On the worksheet labeled "TABLE", I have a table of part numbers(column A) that relate with each of my locations (account numbers) Columns B through P. Each...

I am making a label template, and would like to use a single cell to change the references within my bigger formulas. For example: =Sheet2!D11&" - "&"$"&Sheet2!M11 is one of my existing formulas Is there a way to make the "11" parts reference to another cell like N49? I know it would not work...

I have this Excel spreadsheet that will basically work as a database. It will always be around 400 rows and 10 columns. The information in the columns varies according to the entry in the Userforms. I'm managing the process of producing parts in the Factory with this worksheet. Everything runs...

I have 400,000 Unique parts, from all countries on 1 tab. I have 12 other tabs, one for each country with a unique list of parts for that country. Some parts are in more than one country. maybe one other country, maybe 5. All of my tabs for each country as a named range for its unique parts...

Hello! I am trying to create a Parts Order list that automatically updates as items are added to the Bill of Materials. Given the first table, I am trying to create a table that will update the quantity of items already in the bill, and add new items that aren't already on the Parts Order list...

Hi, I currently have a 'parts' spreadsheet, in column 'A' I have recorded all of the part codes. In a folder on my drive I have the drawings to all of these parts. What I want to do is hyperlink the drawings to the part code in column 'A' of the spreadsheet, there are over 300 parts to this so...

I have a cell that contains a full address e.g. Flat 10, 1 London Road, Bromley, Kent, BR1 1AA. I would like to be able to extract each of the parts of the address that are seperated by a comma. I have managed to get the first line with: =LEFT(A1,FIND(", ",A1-1) And the second with...

Hi Everyone I am having a difficult time trying to figure out how to accomplish the following task. I have a parts inventory, or parts storage workbook that tracks where parts are kept, or where they are located at. It utilizes part Numbers and a BiN# locations to Identify where the parts are...

Hello, I have a large workbook which does a ton of engineering calculations to select which parts to use in a construction product. One sheet in this workbook contains a list of parts, which I'd like to copy to another workbook which handles the pricing and ordering. Essentially, I want a...