software

Can I copy ALL formats from one worksheet to another, especially including
cell width?

is there a way I can enter a Data Validation formula that refers to a list of
cells in another sheet of the same workbook ?

This is a repost, but I still badly need help and my deadline is basically
here...

I have a file that is on a shared drive that multiple users use. The file is
not saved as a shared workbook. The file is password protected and all users

I'm using MS Excel with a command button that calls a simple script to
refresh data queries in the spreadsheet. When I click the command

Sheet 1:

Does anyone know if there is a way to use the if function to search for

I can't save them. Even tried creating a new toolbar and it wouldn't save.
Any ideas?

I'm trying to set the value of cells to exactly the following: