confidential

  1. C

    Copy Multiple Columns and Paste to Different Sheets based on Header

    Hi All! I'm creating a dataset type of spreadsheet where I monitor data of three different types for example distance , velocity and acceleration. Each has its own sheet and results are logged for different years 2015,16,17,18 etc. Id like to program an input data tab where i can paste the...
  2. E

    Include sheet name in formula - look at different sheet

    Hi I'm creating an Excel workbook that contains edited info from another (to send to a third party, so hiding is not an option) Both are made up of numerous tabs. My current formula is: ='[Z CONFIDENTIAL MASTER EQUIPMENT LIST.xls]B2 01'!C10 Is there a way to replace the bold tab name in the...
  3. G

    Excel Security

    I have a spreadsheet that has confidential information. I know how to lock the sheet and hide the confidential info that is not the problem, What I want to know is there a way to have two levels of security. Two different passwords to open more or less. Some people need to see the confidential...
  4. N

    Protect worksheet from formula referencing

    I'm managing a workbook that includes payroll information, which contains confidential information like hourly wages. Each payperiod I reset the workbook and advance the calendar dates so my assistant can enter in the hours worked for each employee. Each employee has their own worksheet. All the...
  5. R

    Remove Value from External Links

    Hello I have a large property detail workbook with a column on one worksheet pulling some confidential data from another separate workbook. This works fine. I would like this confidential data to be removed once I close the property detail workbook but leave the links in place so that the...

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