M
Mark E Philpot
Hello,
Why have users past to the target sheet when the target
shet can validate and detemine the content of the users
sheet. U se the on change event of the worksheet. A macro
is used to automate your requirements. It can send a
msgbox to the user to tell them incorrect data, if
required.
Private Sub Worksheet_Change(ByVal Target As Range)
'macro goes here to validate cell entries.
End Sub
I can create something for you if you cannot manage it. I
will require dummy sheets and more info, of not more than
1mb as my mailbox suffers with "overweight" problems.
regards
Mark E. Philpot
http://au.geocities.com/excelmarksway
the list. For this I want the data owners ( DO ) from each
location/site to mail me only the additions/updations
which wud have occured since last week. I have prepared
the format which the DO will use for relaying the
information to me. In the same vein I dont want the DO's
to tamper with the format like some columns have
date/number formatting etc. I want to ensure that DO's
dont overwrite the formatting for the individual columns.
If I set up a vaildation it can easily be overwritten by
cpoying some other cell's contents in to it. I tried
validation along with Excel's password features. I think
correct combination of password protection options and
creating a template may be the solution but the Excel's
help ( I have 2002 excel ) doesnt have any
decent/explanatory writeups on what a Template is ( and
how I could customise it ) and what each protection option
means. Please guide me.
Why have users past to the target sheet when the target
shet can validate and detemine the content of the users
sheet. U se the on change event of the worksheet. A macro
is used to automate your requirements. It can send a
msgbox to the user to tell them incorrect data, if
required.
Private Sub Worksheet_Change(ByVal Target As Range)
'macro goes here to validate cell entries.
End Sub
I can create something for you if you cannot manage it. I
will require dummy sheets and more info, of not more than
1mb as my mailbox suffers with "overweight" problems.
regards
Mark E. Philpot
http://au.geocities.com/excelmarksway
of my company. At the end of Each week I want to update
the list. For this I want the data owners ( DO ) from each
location/site to mail me only the additions/updations
which wud have occured since last week. I have prepared
the format which the DO will use for relaying the
information to me. In the same vein I dont want the DO's
to tamper with the format like some columns have
date/number formatting etc. I want to ensure that DO's
dont overwrite the formatting for the individual columns.
If I set up a vaildation it can easily be overwritten by
cpoying some other cell's contents in to it. I tried
validation along with Excel's password features. I think
correct combination of password protection options and
creating a template may be the solution but the Excel's
help ( I have 2002 excel ) doesnt have any
decent/explanatory writeups on what a Template is ( and
how I could customise it ) and what each protection option
means. Please guide me.