perfect

  1. jmacleary

    Watermark problems in excel 2007

    Hello folks. I have a problem with adding a watermark. I have followed the instructions given by a number of people on the web (including microsoft) and on this forum and added my jpeg into the header of my worksheet. In print preview, it looks perfect, but when I print, the watermark obscures...
  2. I

    Width of several columns alignment

    Morning, I have a template of which i use for invoices. I have made some alterations to the columns & what are in the cells but now my overall width is larger so when i preview it then you can see some is cut off etc. I use the same template for another company of which this hasnt been altered...
  3. C

    Tearing My Hair Out

    Hope someone can tell me what I am doing wrong. I have copied and pasted from this web page: https://www.mrexcel.com/news/next-invoice-number/ and have corrected all the cell numbers to do with my saving details, and the macro is perfect. BUT, when I then go in to the invoices again, to...
  4. Welsh Mark3

    Using Logic to get first and last name from cell with fulls names

    I have a columns of data that contains a persons full name, which I am trying to split into first and last name. I could use the text to columns feature and use space as the delimiter, but this is not 100% perfect. Some scenarios that cause issues ar e Mark A Edwards Mark Edwards Sr Mark A...
  5. R

    In a Pivot Table, how to subtract Sums of Values from a fixed value?

    So I am building this spreadsheet to monitor our suppliers. Each delivery a supplier makes gets grades for several different aspects, like documentation compliance, quality, ponctuality, etc, etc. The grades for each delivery are summed and multiplied by -1. Because if everything was perfect...
  6. P

    All training from 0000000 to 3333333 without repetitions.

    All training from 0000000 to 3333333 without repetitions. Ex = 0000000 0000001 Can not have 0000100 = because it is repeating 0000001 It has to stay the perfect matrix of 7 houses
  7. B

    Input data based on criteria

    I have a sheet that I need to complete. I need to enter data where cells would popluate value based on criteria. Example: Criteria is male or female in cell A1 The follwing cells next to it would be based on male or female standards. If its a male, they did 40 pushups then they get a perfect...
  8. B

    Inputing data based on criteria

    I have a sheet that I need to complete. I need to enter data where cells would popluate value based on criteria. Example: Criteria is male or female in cell A1 The follwing cells next to it would be based on male or female standards. If its a male, they did 40 pushups then they get a perfect...
  9. E

    Hide ribbon / Tabs in Excel with VBA

    Hi there, I found To hide the entire Ribbon on start up of the workbook. Works perfect. But I want to have the save and print options visible. Do you guys have any solution for that? Tx!

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