sufianmalik
Board Regular
- Joined
- May 7, 2002
- Messages
- 128
If i link a bunch of cells in a worksheet with a bunch in another worksheet. We know that a chnage in data in one will change the other. If new rows/columns are added it will continue to update.
Anyway of changing this? So that if a new row is added the second worksheet doesn't update perhaps coming up with N/A instead. I've just thought of Vlookups, any alternative?
Anyway of changing this? So that if a new row is added the second worksheet doesn't update perhaps coming up with N/A instead. I've just thought of Vlookups, any alternative?