cover

Hi all, I'm looking for help in changing the following code as it is currently set to copy from a specific cell, the problem I have is that I have no guarantee that the data will stay in those same cells. The one constant is that the figures will always be at the bottom of the column even if...

This one is a bit difficult for me to explain, so i included screenshots to help....maybe I've have to cover some of the data as its personal information https://imgur.com/cFDqyS8 source<source <source (separate="" worksheet) https://imgur.com/jdC0Ii9 destination<destination<destination...

Hello All, If anyone can you assist I would be greatly appreciate it. Ex.: I have a list of 10 Employees that do various jobs. Of those 10 employees, 3 employees cover the job of the person(s) on Vacation. The maximum number employees on vacations is 3. I would like to show (in a excel...

Hi. Please can anyone help? The dog is one. Last year cover was £115.08 for the year and this year has been quoted as £128.88 which is an increase of nearly 12%. It seems from search of the web that by the age of 8 the premium will have increased by about 34% and when he is 15 it will have...

I am adapting an old workbook for a new training program. I would like to rename each sheet by employee name but the way it is structured that format is not working. The cover sheet has a drop down to navigate to the employee page but it will not display the name unless i name the sheets 1,2,3...

Hi, I am trying to copy the first 250 rows of data from 1 workbook to another so the daily file I use doesn't get too big. What I want to happen is the following: 1. Select and copy or cut the first 250 rows. Filename PO Cover 2. Paste onto file name Book1 but looking for the first blank row...

Hi I am trying to make a cover page with a picture filling the whole page. I would like the cover page to: a) be automatically added as the first page, when printing a worksheet (report), and b) have title and headlines automatically filled depending on which woorksheet/report I choose for...

I have a list of part types in column E1:E57. In cell F59, I want to add up all the ones that include the word "Cover", but I don't want it to include any that contain the word "service". Like this: Sheet1 <colgroup><col style="font-weight:bold; width:30px; "><col...

Hi all I have a table, pasted below, which shows the daily cover status for different areas at work. I need a way (perhaps VBA) to automatically print / generate a table showing: 1) Today only 2) Listing the ones without cover in the AM 3) Listing the ones without cover in the PM (examples two...

<code>How Can I write an if statement to cover all the below rules?</code> <code>If A1 = “yes” and B2 = "fast" then “ok”</code> <code>but if C2 = “yes” and D2 = "pen" then “bright”</code> <code>but if E2 = “yes” and F2 = yes then “light”</code> <code>if G2 = “yes” and E2 = No and H2= "below"...

Hi all, Using the very simplified and cut down (and I don't run a fruit stall!!!) version of a purchasing sheet that I am trying to improve for someone, I was wondering if I could have some advice please... It's very simple, they use this sheet to decide what stock to buy. Opening stock...

Help- Need help please adding hyperlinks to each sheet in my workbook. I have a "cover sheet" sheet which has a table of contents and each line item is simply all the sheet names in the workbook and the sheet name is a link to the individual sheets. I'm trying to make it easy for the end-user...

Hello. Is there a way to create a multiple substitution so that for a number of specific characters I get different ones? I need this for transposition of notes in music. So for example, for each letter "C" I get a "G", for a "D" an "A" and so on. The thing is that to cover up all the scale, I...