Search results for query: *

Hello everyone Thank you for the replies. The option that works for me is the Find/Replace with Wildcards: \{*\} I hadn't used the \ when I tried originally. The other methods didn't work because the original Word document had the indexing codes all showing and then it was saved to PDF...

...the index code in there too. Once converted from PDF to Word, I thought that if I used find/replace with Wildcards that I could search for {XE*} where * is whatever the index text is and replace it with nothing. But I'm getting an error message: "The Find What text contains a Pattern Match...

Excellent - thank you so much. The tax rate is a reclaim value and it's been that for over 15 years - I doubt it'll change! thank you for helping ____________ Pendle

Yes, rounded for pence - £50,317.36 thank you for helping ____________ Pendle

...and calculate 92% of that total and then add the total of NICs. In my total cell C94 I have the following formulae: =SUMIF(B5:B85,"SPP",C5:C85)*OR(B5:B85,"SMP",C5:C85)*92% Which gives me the £317.36 value that I need, but I can't get the NICs value in. I've tried adding another *OR and...

*** solved it**** So what I did was create a new custom tab with my items in groups Then right-clicked the group and added to quick access toolbar and there is a blue blob with the items underneath. Haven't worked out how to change the icon - but that's fine with me. thank you for helping...

Hello there, I have a lot of useful shortcuts and macros on my QAT in Excel. Some of them I'd like to group into a sub-menu. Just like the regular ribbon has groups and sub-menus. I can't see how to do this, but I'm guessing it's not an option, but has anyone found how to do this? Or are...

Hello I had some free time this afternoon and I'm sorted, thank you both for your suggestions which got me on my way. For anyone with a similar issue, here's what I did: I selected all the cells that I wanted to be a particular colour, I then named this "fields" In cell A2, I had my dropdown...

Hi both, Thinking about it, I could name each cell that requires completing - it's quite simple, name, start date, salary blah blah and try colouring them that way. thank you for helping ____________ Pendle

Hello I have a number of forms in different colour schemes. The content is the same. What I'd like to do is pick my company name from the drop down list in cell A2 and depending on which company is selected, will change the colours of other cells in the worksheet. These cells will be empty...

Thank you for the replies. I've used the EOMONTH formula as that gives me the actual pay date which is what I'm needing. I've then used 1, 2,3 etc down the column to move the months on. thank you for helping ____________ Pendle

Hello I'm not sure if this can be done via a formula or if VB is required. I have some maternity pay calculations and I need the paydate cells to be 25th of whatever the month is. For example: Employee goes on mat leave on 23 March, so the paydate cell needs to be 25 March, if they go on mat...

Hello The host company for my website has done some updates and now uses Site Tools rather than CPanel, and the version of Perl is now v5.30.3 The support team have advised that my search scripts should be updated to the latest version of Perl. Sorry if this is a stupid question, but what...

Hi there I'm sorted now thank you - I just deleted everything and left it overnight, uploaded again and now it's fine. I've no idea what the problem was but it's viewing fine and that's all I'm fussed about! Thank you for checking and taking the time to reply. thank you for helping...

Hello I've just uploaded some pages to a new website at www.ballamonamentalhealth.im The pages were originally on another site for testing purposes and these all looked exactly as intended. So I didn't envisage any problems when loading to the new host - netcetera in the Isle of Man. The...

That's worked perfectly, thank you. thank you for helping ____________ Pendle

Hello The macro itself is sitting in personal.xlsb and there are no other macros in the workbook I'm needing to run this on. thank you for helping ____________ Pendle

Hello Each month I need to create a report from some extracted data. There is just one worksheet, and the name varies from month to month. What I'd like to do is have Excel just select that Worksheet. What the macro needs to do is sort the records into a specific order - the employee number...

Hello - sorry to have taken so long - all is working just fine and saving me lots of time! Thank you everyone for your help. thank you for helping ____________ Pendle

Just to say I haven't had a chance to sit down to this yet, but I'll let you know how I get on. thank you for helping ____________ Pendle