Search results

Hi Looking for some tips on where to begin with this one. I've got the data on one page as I extract it from SQLserver. I am looking for some guidance on how to get it to look more like the Idea page. Any pointer or advice would be more than welcome, many thanks in antisapation...

On using the following macro I can email each sheet of a spreadsheet to the named user of that spreadsheet. I would like to add some guidance notes into the body of the email. I get the Subject in ok , but unsure how to get into the body of the email. Sub Mail_Every_Worksheet() 'Working in...

Macros Created for all colums do be sorted , how ever they all work on Voyage A , but mix up the ansers on Voyage B and C, so I recon it's the frmula that being problematic and not the macro. I admit I have posted this recently butI've been assured that my macros are ok, so I can see the...

Hi, as you will see by the sample I've provided, the pages sort but column D get all mixed up . How can I ensure that all the data is sorted correctly. there is formula in Column D , which I belive may be causing the problem. Any advise would be appreciated Eccel 2007-10 Sub Comments() Dim...

I was wondering if any one out there can see better than I can. I've created a sort that sorts data on multiple worksheets at the same time, depending on which macro selected A B C D it will sort the whole data by that column. The data start on row A6 in ever sheets with the titles above it. A...

Cell A1 has 10000 and cell A2 has 5000. B1 has the formula of =IF(A1>40040,(((A1-40040)*13.8%)+(((40040-7488)*10.4%)-(65.26))),(((A1-7488)*10.4%)-(65.26))) Cel B2 has the same formula, but returns a negative number e.g. -324.012 What I want is if the number is negative return 0. I have...