Hi im creating a working doument which will have three sheets, one is a waiting list, the second is a current client list, and the third would be archived. What I would like is to be able to create the watining list which ive done, then in the current if I enter into B2 for example a number which features in B2 on the preious sheet, to then copy the entirity of the data from that row, however the cells on the second sheet are not the same. e.eg. H2 is parent contact on sheet one by J2 is that on sheet 2.
Any ideas welcome
Bookmarks