- Joined
- Oct 2, 2014
- Messages
- 4
- Reaction score
- 0
- Points
- 1
I want to be able to Dynamically add a row to a named range (A1:B6 named DNAME) for example, so that when I add information in Row 7, DNAME will change to A1:B7, and I can then do a Vlookup from another sheet, something like Vlookup(2,DNAME,2,false).
Cust# Sales
1 33
2 4
3 55
4 66
5 77
6 999
Cust# Sales
1 33
2 4
3 55
4 66
5 77
6 999