part

Hello, I have a large, 45 tab spreadsheet which the current code appears to be hanging, or at least is taking a very long time to run (even left overnight to no avail). The spreadsheet consists of the first tab, Location_Summary (an 11,000 list of part numbers) with the subsequent tabs being...

Hi all :nya: First time poster, great to be here! I've always been a big fan of Excel ;) I'm wondering if you could help me with a requirement I have please. We have two columns, one is our part number, and another is a supplier's part number: <tbody> Our Part Number Supplier's Part Number...

Hi all, I think I'm overthinking this for certain, but could use some help. I have an Excel Workbook that contains a number of worksheets related to ‘special’orders that I am required to place, progress and track through to receipt. The sheetsare named as follows “Demands”, “Cleared”...

Hi all, I think I'm overthinking this for certain, but could use some help. I have an Excel Workbook that contains a number of worksheets related to ‘special’orders that I am required to place, progress and track through to receipt. The sheetsare named as follows “Demands”, “Cleared”...

Hi All...I am certainly not a master VBA'r, and I cannot find a way to solve the following problem. I start with a 2 column data set of varying lengths. Column A has Product codes and Column B has Product information. One of the codes is "PN" in column A, this "PN" indicates the start of a new...

Evening, For some reason a certain part number in my worksheet doesnt get entered correctly. So can somebody wright me a simple code to find this number in a specific column & once found replace it with the correct number. This is the infro that you will require to assist you. Worksheet is...

Hi, I have a query. I have a 2 tables of data, similar to below and basically I need to analyse how many pallets move in and out in a month, the raw data is inputted on the the bottom table but I want to know if there is a way to do a vlookup or IF function to basically add in the total number...

I was testing for bottlenecks in some project finance code to test for IRR and the bottle next appears to be on bit where the range is moved before a recalculation occurs to see how far away the answer is from being solved. Call MoveDate(Names("CopyRange").RefersToRange...

Every third or fourth time I open this workbook I get the error "Removed Records: Sorting from /xl/tables/table2.xml part (Table)" I have no Idea what to do. Any Ideas?

Formula: =N24&TEXT($P$25,"+#.#,,;[Red]-#.#,") This formula is part of a sentence. I need the format of P25 to be +##.# or -##.# regardless of the value. Therefore I need a dynamic formula to factor it if the value is over or under 1,000,000. The current formula will work if my value is in...

Hello, I have 27 rows listed # to Z. What I'm trying to do is count how many entries in my table begin with each letter as well as 0-9. I've been able to figure out the A-Z part but the number part eludes me. The numbers are formatted as text but also I'd like to combine them in such a way...

I collect information from about 200 constituents using an excel ‘form’. Each file has a “Department Only” tab where we are trying to total some of the other tabs. I anticipate there could be up to ten tabs. I would like to use a macro or VBA to place the potential name of each tab (below) in...

I need to merge two excel sheets with part lists but not have the part numbers duplicate. i was told to use conditional formatting inside the spreadsheet, if + match. I am clueless.

Hello, I a have a spreadsheet of about 1600 rows in which I need to get into another format.... <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> Part ID Amount 79123 5233122 44.18 79123 11606476 95.1 79123 22346192 149.81...

Hi, good afternoon, hope you can help I have the code below which is part vlookup and part vba but it doesn't work, I want it to go into cell C2 then drag it down to the last column, but all it does is paste the same code into each cell and does nothing hope you can help. [CODE]Private Sub...

Hi Guys i have some data i get with two basic columns part number and image link, i need to import these into my site with the first column being the part number and the image link, then the next image link here is one image link ( i did this ) <colgroup><col><col></colgroup><tbody> sku pic...

Hi all, I got a spreadsheet from someone else and I'm curious as to what part of the formula does. It seems to work without the *LEFT($G5,2) in it. Here is my formula: =INDEX('AER Export'!$A:$N,MATCH($B5,'AER Export'!$A:$A,0,8)*LEFT($G5,2) I have never used the * as part of an INDEX MATCH...

A kind soul helped me out with this the other day. Now I have a subsequent question: How do I set a variable to this value? Here's what I'm trying to do: Set MyFile = Workbooks(" & Range("B1") & " " & Range("C1") & ".xlsx") so it would end up being: Set MyFile = Workbooks(Donors April.xlsx)...

I have a spread sheet that if the number of units is greater than zero I have it returning the name of the product. I want to use index with that. First do i have to use match with it? How can I use the if and index together? Here is a formula i was trying to use. Column B is the part name and...

Good Afternoon, I found help here (many times) Currently I have a Spreadsheet that will expand (unhide rows) based on a color selection in column "a". That part work GREAT (see lines 3-7) of code below. I am attempting to see if i can add a layer (for future requests). My attempt (one of...