Question

Locked

Do I need VBA or a macro?

By jcates592 ·
Hey, first I like to say thank you for all that help.

Question:
I am not sure if it is possible, but what I am trying to do is create a cover sheet for a workbook and then Create a space where you enter a number (a control number) and another number (master key number) and then another number (change key) and it shows data that is reference on one of the workbook sheets.

Data is shown on sheets as follows:
Control Number (Row)
Master key number (refers to which worksheet holds the correct data) (ex. Chart 1 will hold Master Key 0, Chart 2 will hold Master Key 1, and so forth)
Change Key (column)
and after entering the desired numbers for the above it shows the data that it refers to in the worksheet of the correct reference. And it then displays the data of on the front cover. If anyone needs the workbook to see what I am trying to do please email me and I will send it to you.

Example of what I am trying to do is below:

Control (doesn't change)..0 1 2 3 4 5 6 7 8 9
-----------------------------------------------
Master (say they enter 1).1 1 1 1 1 1 1 1 1 1
------------------------------------------------
Change (even or odd and doesn't change- the below column on left)
----------------------------------------------
0.|........................2
..|........................4
..|........................8
..|........................9
----------------------------------------------
2.|
..|
..|
..|
----------------------------------------------
4.|
..|
..|
..|
----------------------------------------------
6.|
..|
..|
..|
----------------------------------------------
8.|
..|
..|
..|
----------------------------------------------

Say the user enters
Change Number of: 0
Master Key Number of: 1
and
Control Number of: 0

it displays the data like this:
2
4
8
9
on the cover sheet..

Is it possible and if so can anyone help me?

Thank you
(note the numbers in the post are suppose to be in a column, but it moves when I post it)

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums