piece

  1. T

    VBA - Formatting range based on formula / rows count

    Hi guys, I'm really struggling to code / piece together a code that factors in the situations I require. I'll piece it together below: --------- The range: .Range(K5:BM" & .Cells(.Rows.Count, "A").End(xlUp).Row) I need it to apply the formula based on the last piece of information in column...
  2. S

    Need formula to find match, then divide bulk pricing to produce total price per piece.

    Hello, I have a master list that includes crates and individual piece pricing. When this was originally setup, it was all manual. There are thousands of items and pricing changes do occur. I have received updated pricing for crates, but not individual pieces. I need help creating a formula...
  3. J

    Split cell at transition from number to any other character

    Say we have "100112model2", I want to split out the 100112 piece. The kicker for me is its not left(a1, 6) because the count of numbers before the first non-numeric character is variable. Could also "4432/mebb4" - Here again I need the 4432 piece. Thanks
  4. B

    VBA to connect to an Oracle database

    Hi There, I am trying to connect to an oracle database with no success... If I use an SQL tool (Rapid) I have to add the server name. port number and Service name. I have Oracle installed on my PC (Oracle Client 11g and Oracle Client ORA Files). I have goggled about and cannot find a piece of...
  5. M

    pie chart for each slice of a pie

    I have two sets of categories (i.e., product and items within that product type) and I want an overall pie chart of the product costs and then I want to click on any piece of the pie (i.e., any product type) and have a pie chart appear of the various items within that product type.

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