Hello,
I wonder if any can guide me.
I have a vlookup formulas in sheet 1 which relate to data in sheet 2.
When a particular code number is typed in a cell in sheet 1 it populates some cells with information from sheet 2 using a vlookup.
However for some code numbers I need a second row to be added. So I would like when a particular value is typed for a second row to be added (which will contain the same data as the first entry; except for one cell; but don't worry about that for now).
My question is; does anyone know if what I want is possible ? And if so can anyone offer some advice on how I can complete this.
Thanks to everyone that considers this post.
El.
Bookmarks