Kevineamon
New Member
- Joined
- Aug 1, 2018
- Messages
- 27
Hi guys
Bit of a weird problem here I can't wrap my head around.
Ok
So I have this table that dynamically expands. There's a column on it, which I need to be a list. So I've tried to use data validation lists.
Here's the problem:- There's "a signature" that dynamically appears, 2 rows after the column ends.
I think the best solution would be to have the list function, stop at the end of the table, if such a thing were possible.
Remember this table constantly changes height.
The signature's not included in the list, so it won't accept the input obviously.
There doesn't seem to be a list function available. That would be perfect.
So basically I need:-
if <= ("tablesize") list, else if > ("tablesize" +2) signature
I use the table with excel online so I can't have macros
Bit of a weird problem here I can't wrap my head around.
Ok
So I have this table that dynamically expands. There's a column on it, which I need to be a list. So I've tried to use data validation lists.
Here's the problem:- There's "a signature" that dynamically appears, 2 rows after the column ends.
I think the best solution would be to have the list function, stop at the end of the table, if such a thing were possible.
Remember this table constantly changes height.
The signature's not included in the list, so it won't accept the input obviously.
There doesn't seem to be a list function available. That would be perfect.
So basically I need:-
if <= ("tablesize") list, else if > ("tablesize" +2) signature
I use the table with excel online so I can't have macros
