Single Point Data Entry Worksheet?

[Keith]

Hello,

I am creating a workbook that will help me to value publicly traded
companies. I have different worksheets for each year of earnings and then
each worksheet is broken down into 4 quarters with all the information from
the company's quarterly and annual SEC filing. I then derive various ratios
and percentages from these numbers on another worksheet. What I would like
to know is how do I create one worksheet (or form, or something) where I can
pick which year and then which quarter and then enter the specific fields
which are the same for every worksheet. Here is a quick example:
Year = FY2004 (this would be a worksheet)
Quarter = Q1 (This would be the particular heading)

-I want a "Fiscal Year" cell that has a drop-down list that will specify
which worksheet I want the data entered on
-then I want the next cell to have a drop-down list that will specify which
"Quarter" of that year I want the data entered under
-then I want to have all the individual headings and cells to enter the
numbers for that quarter

I'm not really concerned whether it is one form or one worksheet I just want
a single point to enter data entry for several worksheets that are formatted
exactly the same

I know this may be a tall order but I have already spent so many weeks
piecing this workbook together and any help would be greatly appreciated.

Cheers,
Keith

 

[Otto Moehrbach]

Keith
I'll try to help you with this. Your idea of having one sheet for data
entry is good. Setup an otherwise blank worksheet with the headers that you
want for the data that you want to enter. Indicate which cells you want to
setup with Data Validation. Clearly show where the various lists for the
Data Validation cells are located. Then send me that file and I'll write up
some code to make it work like you want. I need just the layout of all the
sheets, so you can enter fake data if you feel your data is proprietary. My
email address is (e-mail address removed). Remove the "nop" from this address.
HTH Otto