Repeat Entry

[one_more_cave_dweller]

I have a macro that copies information from a sheet each day and pastes it horizontally into a summary sheet for the month. (a1=1st, a2=2nd etc.).
The macro is triggered by a control button the user clicks after they have entered the information. How can I stop them from entering the same day twice?

Thanks

 

[jim may]

Assume your data is to be entered between A3:A25

Click on A4 making it active, then highlight
A4:A25;
Go to the menu, Data, Validation,
Select Custom form top box,
in formula box enter the below formula:

=IF(COUNTIF($A$3:$A4,$A4)=1,TRUE,FALSE)

On Tab 3 enter a message if desired.
OK Out

 

[one_more_cave_dweller]

Thanks Jim that works except one thing, the sheet that I am copying to is colored. Is there a way to just copy the value and not the color of the cell?

Thanks ray:

 

[jim may]

Can you post the code attached to the control button?
It probably is going to need to be modified so as to paste-special
values.
Jim