Search results for query: *

Hello everyone I've a PDF document which has the index codes {XE "blah"} visible within it and I've been asked if they can possibly be removed. The document is in 18th century English and is hard enough to read without the index code in there too. Once converted from PDF to Word, I thought...

Hello I'm trying to total some items for a report. I have a table of a number of items with values, I'm interested in these ones: B C SPP 344.96 SMP 0.00 NICs 50,000 In my totals area I want to add SMP and SPP and calculate 92% of that total and...

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

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

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

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 I've mostly dealt with macros that go from A to B to C without having to stop for user input so this is a new thing for me. What I'm doing is adding in names against a record, but it's not a specific name it could be A or B. At the moment I'm doing copy/paste and the repetition is...

Hello G5 contains a code - could be anything but if there is a K in that code then I want, cell C19 to run a formula: value in G6 divided by 12 multiply by -1 to give a negative figure. But if there's a K in G5 then I want just G6 divided by 12. What I have at the moment is...

Hello I've two reports detailing absences. The first is the 'clean' report with the correct items, around 600 rows. An example is: Number Type StartDate EndDate Hours 123456 LSL 30/07/2018 30/07/2018 7.6 123456 LSL 31/07/2018 31/07/2018 7.6 123456 LSL 01/08/2018 01/08/2018 7.6 987654...

Hello I've a copyright sentence which goes at the bottom of every web page - unfortunately there are over 5000 of these pages (all transcripts of old documents). Is there a HTML tag which might "import" this line? They are static HTML pages, but I would like to update one file with the...

Hi Part of my routine uses Save As to open a dialog box at the folder "overtime files" so that the user can name and save the workbook. I've looked around and come up with the following: Sub Otime_SaveFile() Dim varResult As Variant ChDrive "C" ChDir "C:\Documents\Overtime Files\"...

Hi Part of my routine uses Save As to open a dialog box at the folder "overtime files" so that the user can name and save the workbook. I've looked around and come up with the following: Sub Otime_SaveFile() Dim varResult As Variant ChDrive "C" ChDir "C:\Documents\Overtime Files\"...

Hello In my spreadsheet I want to delete columns which have "pension" contained in any header cells. Dim rng As Range Dim cell As Range Dim ContainWord As String 'What range do you want to search? Set rng = Range("A1:HZ1") 'What phrase do you want to test for? ContainWord = "Pension"...

Hello I've a spreadsheet with about 30 columns of figures. I've created my table, and what I need to do is put the total of each column at the bottom. When creating table, I ticked the Totals row option which has given me a Total dropdown in A438, but I need the totals in B438, C438 etc also...

Hello I have a workbook with lots of sheets in it, and I want to embed it into a webpage. I've got the file loaded onto my OneDrive, picked the 'embed' option from the right-click menu and then followed the instructions. All is well and good there, but my problem is that little icon at...

Hello and happy Christmas I've got several thousand documents which are transcriptions of Wills. The <pre> tag is around the transcription. In my CSS I currently have: pre {font-family: monospace; font-size: 1.75em; line-height: 1.75em; } Because of the nature of the documents, a lot...

Hello have a template workbook shakeout.xltm - what I want to do when running my macro is: on click: open file dialog box which is at P:\data\misc It to pause while I pick the xlsx file I want to use (there will be new files each month, so I can't hard code the filename) When I've picked...

Hello I can't believe this is causing me to much bother! I have a template workbook shakeout.xltm - what I want to do when running my macro is: on click: open file dialog box which is at P:\data\misc It to pause while I pick the xlsx file I want to use (there will be new files each month...