Default values vor A4 -> A365
Hi all,
I have a data reach dat runs from cell A4 to A365.
Cells A4 to A365 have a validation containing:
- Fill in month
- Januari
- Februari
- ...
- December
is it possible that when Cell C4 is filled in and cell A4 is still empty it gets the default value "Fill in month"
this through the whole data reach A4 -> A365 so when C120 is filled in and A120 is empty it gets the default value "Fill in month"
Thnx in advance
Last edited by Champstaff; 02-10-2012 at 02:09 AM.
Hi
I think that you can not do this(At least by formulas).
But using Custom Validation, you can force users to fil column A, or else they can not fill anything in column C.
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
Pl see the attached file. I have used worksheet_change event for Sheet1.
I feel this what you need.
Any clarifications welcome.
with regards.
Re: Default values vor A4 -> A365
Thnx M8
your example code really helped me a lot
srry for the late reply
thnx again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks