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

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top