conditional input only !-corrected
Hi,
Sorry about my mistakes in the previous post. I think I wasn't very
sucessful giving a
clear view of my problem. Here is a much clearer description of my excel
problem...
-----------
I want to use Input Box's to enter data to columns C2:C, D2;D and E2:E row
by
row on Sheet1 (where the info on column C, D and E will hold the data for
"period",
"activity" and "trainer" respectively).
On Sheet2's A4:A column, I have a list of all possible "tariner" values of
Sheet1.
On Sheet2's B3:AY3 range, I have a list of all possible "period" values of
Sheet1.
Lastly on range B4:AY21 of Sheet2, I use VLOOKUP to display the "activity"
cell info for
the matching "period" and "trainer" values retrieved from Sheet1.
So far so good. No problems. I can manage that.
But before actually accepting and "writing" the data into the columns of
C2:C, D2:D and
E2:E as rows of new elements on Sheet1, I need to make sure that the info
I'll input on
Sheet1 for each row of cells ("period" & "activity" & "trainer" values)
there doesn't exist
another row with the same data trio.
Hope I summerized it correctly this time.
How can I do it?. (With and without VBA)
TIA
J_J
|