Skip to Content
author's profile photo Former Member
Former Member

Locking Data Entry

Hi All,

I want to create an input schedule in that i will put two year 2010 and 2011. My purpose is to lock actual data and to permit to enter data to forecast period.

For example i want create an input schedule like this: http://img210.imageshack.us/img210/5610/sdntarz.jpg

I mean i should close data entry until 2010 oct and i should give permission for data entry until 2011 december. How can i handle it? Any idea?

Thanks in advance.

Edited by: boguner on Aug 19, 2010 12:49 PM

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 19, 2010 at 11:13 AM

    Hi,

    I had published a document on rolling forecast, wherein, you will disable the earler months and enable the future months.

    Please have a look at it in the below link.

    Content at link deleted 21 August 2011

    Hope this helps.

    Edited by: Jason Lax on Aug 21, 2011 1:41 PM

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      I am using excel 2007.

      I go to Data -> Data Validation. It opens a dialogue box for validation. You have 3 tabs there. In the Settings tab, in the allow drop down box, select custom and then specify the formula, which I had mentioned. You can see the tab for "Error Alert".

      Hope this helps.

  • author's profile photo Former Member
    Former Member
    Posted on Aug 19, 2010 at 11:43 AM

    This you can also do by enabling work status. You just locked the time period which you doesn't want to enter

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.