ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,226
- Office Version
- 2007
- Platform
- Windows
Afternoon,
Could you advise please how i can add to my list and have the code update itself.
The code in use is shown below.
My issue is when i add a new line & enter data into AY2 thus making all the current info drop down one row the code i have just added is not updated.
I mean it only remembers the data that i started with and just changes its location so AY2:AY21 then become AY3:AY22
So what i now have in cell AY2 isnt included
I was expecting the code to adjust itself to say AY2:AY22
Could you advise please how i can add to my list and have the code update itself.
The code in use is shown below.
My issue is when i add a new line & enter data into AY2 thus making all the current info drop down one row the code i have just added is not updated.
I mean it only remembers the data that i started with and just changes its location so AY2:AY21 then become AY3:AY22
So what i now have in cell AY2 isnt included
I was expecting the code to adjust itself to say AY2:AY22
Code:
=INFO!$AY$2:$AY$21
