mulitple

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

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

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

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

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

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