Excel Issues

N

nicole

I have several issues:

1. I want to sort w/o using the sort function because I want to keep
the specific formatting of the cell ( I want the cell to move with the
data, with sort the data only moves and the cells stay the same) . I
want to have a function where the selected data will automatically be
sorted so that it moves to the top of the worksheet and the unselected
data either moves below it (in a list that can be deleted)or becomes
hidden when printing.

e.g.

x A
B
C
x D

becomes...

x A
x D
B
C

2. I want to create a check mark function so that the user can check
mark the items that they want to print out(check the items that apply
to their situation) so that the items can be sorted as above. (see
above x) I don't want the check mark to print out when printing, it
is just for sorting purposes.

3. I want the date in the header to be 00/00/0000 instead of the date
being the updated date you get when you press &[DATE]

4. When finished I want to be able to save the data I want to print
out, as a word document.

Thanks.
 
Top