Ok, so I'm going to try and explain exactly what I need the cells to do.
Is it possible to get the cells to automatically do the following?
If for example;
Cell L19 = 'A' (The Letter A)
Cell L20 = '2' (The Number 2)
Then in on sheet 2, column A row 2 must be filled in, either (preferably)
a color or the number 1 or letter T, doesn't really matter what it's
filled with so long as it is filled.
If this is at all possible, can it recognize a range of numbers; e.g.
L19 = 'A'
L20 = 5,6,7,8
How do I get it to fill in Sheet 2 Column A Cell 5 and 6 and 7 and 8 with
whatever I can fill it with.:confused2:
Is it possible to get the cells to automatically do the following?
If for example;
Cell L19 = 'A' (The Letter A)
Cell L20 = '2' (The Number 2)
Then in on sheet 2, column A row 2 must be filled in, either (preferably)
a color or the number 1 or letter T, doesn't really matter what it's
filled with so long as it is filled.
If this is at all possible, can it recognize a range of numbers; e.g.
L19 = 'A'
L20 = 5,6,7,8
How do I get it to fill in Sheet 2 Column A Cell 5 and 6 and 7 and 8 with
whatever I can fill it with.:confused2: