We help IT Professionals succeed at work.
Get Started

Excel force date selection

90 Views
Last Modified: 2017-11-25
I'm developing an Excel file for data entry by users.  The file has 12 tabs.  The data entry area in each tab is no larger than one page.  So, if I was to print the entire file, it would be 12 pages long.

I'm trying to figure out a way to force the users to select the month the data pertains to and have the month appear in the center header of each sheet.  Multiple months across the tabs cannot be used.  The month must be the same on each sheet.

I'm not trying to insert the current month but rather a selected month.   For example, the users may need to generate a report for say, July, 2017.   I want the users to be able to open the file and be forced somewhere along the line (possibly before being able to print or save) to select the month the data pertains to.

Basically there are 2 or 3 users involved; each sharing the file (in sequence, not concurrently) and each responsible for a few of the tabs in the file.   If the first user selects a month, then if all tabs are populated with that selected month, that would be fine.  Or, maybe each user goes through the process of selecting the month but the program looks at the month selected by earlier users and prevents an alternate month from being selected.

Any ideas?  Thanks.
Comment
Watch Question
Consultant and developer
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE