mulitple

  1. Q

    Change Tab colour based of multiple cell values

    Hi team, I've managed to change the Tab colour based of the results of an existing macro in cell "D9" I also need it to look at a second cell "G31" and if there is an "x" in it. The Tab should turn Blue. I also want the purple formatting to take priority if they clash. e.g. If the Macro...
  2. S

    Multiple Formulas in one Cell

    Hello Everyone, Is there a way to apply multiple formula in one single cell? I need to apply 2 formula in one cell "LOWER" & "SUBSTITUTE". For instance: This tex: <tbody> "Lupo Heel N Toe Yoga Barre Pilates Socks" Should be: "lupo-heel-n-toe-yoga-barre-pilates-socks" Any suggestions...
  3. S

    Report from multiple worksheets?

    I must create a report from two worksheets. Can someone point me to a site with how-to’s? <o:p></o:p> Column A in both sheets is the File# and the only common piece of info. Sheet1 has one row of data per file number. Sheet2 has between 1 and 8 rows of data per file number. How can I create...
  4. L

    Macro Print/Page breaks

    Hi, I have a macro that someone very kindly helped me with on another thread (see below) I need this developed a bit more to include a page break at line 70, and also to specific what sheet to apply the whole macro to, i.e. their are 60 sheets in the book, but i only want it to apply this...
  5. K

    Mulitple Check Boxes

    I have a form with 5 check boxes and a command button. When I click the command button I want it to determine what check boxes are clicked and add the captions together in a string. chkbox1.caption "Hand Solder" chkbox2.caption "Mini Wave" chkbox3.caption "X-Ray" chkbox4.caption "Connector...
  6. N

    Combining Multiple Workbooks

    I want to start with an apology as I know this has been asked and answered a hundred times already. I have searched past threads, but still cannot implement the solutions you all have been so gracious in providing. So here is the issue: I have a folder with several workbooks. I need to pull...

Watch MrExcel Video

This Week's Hot Topics

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
Top