part

  1. H

    Large Spreadsheet, VBA code is hanging.

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

    Complex Conditional Formatting

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

    VBA - append text to existing cell entry for all cells in column

    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”...
  4. S

    VBA - Update information in all cells within a column

    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”...
  5. J

    Converting Vertical data to Selected Horizontal data

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

    Simple Find & Replace code required

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

    Using either vlookup or IF function

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

    Slow - VBA Copy Paste recalculate

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

    Removed Records: Sorting from /xl/tables/table2.xml part (Table)

    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?
  10. R

    Dynamic formula value as part of sentence

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

    Count how many entries begins with a number

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

    VBA/Macro to insert text, formulas, and sum

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

    merging worksheets

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

    Excel Transpose Help

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

    putting a vlookup into vba code

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

    formula help

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

    Index Match with * LEFT

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

    Set Workbook

    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)...
  19. M

    Using IF and Index together

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

    Cascading color commands (code included)

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top