Search results

Hi Xld Many thanks for that, some very usful calculations and idea there. I've saved this one for future ref. The data I get back from the server is pependant on the register number I enter. So if I were to ask for another register number it may give a different set of days time etc.., I'll go...

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

Thanks Luke, and for finding wher I got the macro originaly, so I've added credits to his work on it. I just though there may be something I was missing , as I'm using GroupWise....thanks again

That didn't go to well....code here http://speedy.sh/uD4aZ/macrormail.txt

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

When the job is completed the due will be overwritten with the date and the next pages will resume again, as they did in Voyage B thank again for all your efforts . It is really appreciated.

Wow !!!!! I need a vodka to digest that one. I'll leave it until the morning , once my braincells have got otgether again after reading it. thanks a million for that. Have anice day

It may be the formula that is in B and C sheets http://speedy.sh/URpQd/Small-with-added-VBA.xlsm Due On Completed =IF('Voyage A'!E5=0,"",'Voyage A'!E5+30) 40945 =IF('Voyage A'!E9=0,"",'Voyage A'!E9+30) 40948 =IF('Voyage A'!E11=0,"",'Voyage A'!E11+30)...

Hi SirJB7 Ok I've gon with option 2, although a bit out of my depth. Have alook at the file. I think I have created it correctly but errors are still there.The only time the error is not there is when sorting by column Voyage A in every sheet. Unless of cousre I haven't correctly done what you...

Thanks Hui, hope to hear from you again tommorow

Ok Hui, I'll try and make myself clearer, click on Voyage a and sort by clicking on the grey macro "JOB" and you can see D8 hase the value of 9-Jan-12. If you go to Voyage B they are also sorted correctly with 9-Jan-12. On voyage B click on the Desription macro and the cell in question now is...

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 I've shortened the file to show that it may not be the macro thats the problem , but more the formula. If you check sheets Voyage B and C you will see the highlighted date change, as you run through the macros for the sort. Hope you see what I'm speaking about...

Hi, if you got to voyage A and sort by Job, then go to Voyage B check out the dates in row 7 both are Due On 7th and Completed on the 7th. If you click on Done By and scroll down to row 42 you will see that the dates have changed to Due On 9th and Completed on the 7th, thanks

http://speedy.sh/J8J6Y/Copy-of-Deck-Planned-Maintenance-01.xlsm

http://www.2shared.com/fadmin/30553290/43f8f6dd/Copy_of_Deck_Planned_Maintenan.xlsm.html http://speedy.sh/gRnpE/Copy-of-Deck-Planned-Maintenance

Ive add 3 tags , I thought you could download the file from there, There ia a set of macros at the top of r=each page and they should sort the column the are above and everything else. ThaNKS AGAIN FOR LOOKING

To D E Due On Completed =IF('Voyage A'!E5=0,"",'Voyage A'!E5+30) 40945 =IF('Voyage A'!E6=0,"",'Voyage A'!E6+30) 40945 =IF('Voyage A'!E7=0,"",'Voyage A'!E7+30) 40946 =EDATE('Voyage A'!D8,6)...

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

Sorted now.....having taken some vodka....thanks to any one that did read it.

Trying to post a link to a sample

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

Cheers , works a treat......a pint I owe you Narayan, many thanks

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