cover

  1. P

    VBA: Copy specific cells from one workbook to another

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

    Cross reference cell values then copy data between sheets

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

    How to set up formula in excel

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

    Calculate Cost of Lifetime Cover over 15 years for Dog Insurance

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

    Worksheet renaming question

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

    VBA code that copies rows of data from 1 workbook to another.

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

    Coverpage automatically as frontpage when printing

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

    Sum If Cell Contains "this word", but not "this word"

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

    How to?: Daily printout of unstaffed shifts

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

    how can i cover all this in an If statament

    <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"...
  11. S

    Working out "weeks cover"

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

    How put a hyperlink on table of contents page using VBA code?

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

    Multiple substitution?

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top