coffee

  1. B

    Help with a macro please

    Hi Everyone, I have a workbook with Sheet 1 in it. Each day Sheet 1 is updated with up to 600 rows of data. We have several rows that we need to copy data to for example, where Cells A3, A4, B3 & B4 below are empty I would like to copy A2 & B2 and so forth down column A & B. I'm trying to come...
  2. M

    Delete row in Book 2 depending on value of cell B4 in Book 1 - VBA

    Hi I need to write code which loops and deletes rows in a workbook (let's call it Book 2), if the name of a row in column A in Book 2 is the same as the name of cell B4 in Book 1. Please find below some sample data. For Book 1, the name in cell B4 is "Coffee" in this example (but it could...
  3. Z

    Formatting text in cells with html tags

    hello , im hoping i can get some advice on a problem i have. I need to be able to add a simple <p> tag to specific points in my text in excel cells. so for example some of my cells have product descriptions liek this Goodio Raw Chocolate 56% Coffee 48g x 15 Starring sweet, smooth and...
  4. L

    Filter date, showing all dates except 2018s

    Hi I want to filter this table using Date. I do not want to see any date of year 2018. So what I did, select Data Filter -->between after 12/31/2018 before 1/1/2018 But excel showed 0 rows. I tried AND/OR same result I tried After 1/1/2018 Before 12/31/2018 , got same result...
  5. H

    How to use logical formula and retun back an array instead of just 1 cell

    Hello experienced and talented Excel people. Example. I am working for a company and I have segments, brands and variants. Example: Segment:Coffee, tea, chocolate Brands: coffee--> Nescafe, ground coffee Tea --> green tea, freshly cut leaf Chocolate ---> white, dark, 100 cocoa Variants...
    • harsha_1991
    • Thread
    • array a range coffee logical function offset range vlookup & data validation
    • Replies: 1
    • Forum: Excel Questions
  6. E

    VBA to Pick Specific details or split and get the data

    On Column B I have list of different types of descriptions and on column C , D & E I wanted few details from column B (descriptions) as per below example. So where ever the description starts with intelnumr I need a VBA code to pick below details as per below example. For the ones which does...
  7. I

    Randomized Game VBA Coding

    Can somebody please help me code the following question? I don't know where to begin and desperately need help. If somebody could help me code this I will be so very appreciative. A coffee shop is giving away a prize by selling coffee cups with a letter placed under each cup’s rim. To win the...
  8. A

    three level dependent combobox

    Hi, I want 3 combobox in my sheet which are depended upon previous combobox data and final cell display price depended upon combination Data Structure:- Breverage TEA COFFEE TEA GREEN TEA BLACK TEA COFFEE BLACK COFFEE REGULAR COFFEE POTION SMALL MEDIUM LARGE PRICE...

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