Hi there,
I have name and surname in one sheet(sheet 1), and name, surname, address and postcode in the other (sheet 2). Unfortunately I can't just sort, cut and paste because there is a high likelyhood of redundant data.
Now adding to that visual, Sheet 1 is actually 6 separate sheets (from 1st - 6th Grade for a school).
Can someone please give me some very plain English instructions on how to get the address and postcode from Sheet 2 to the other 6 sheets?
Please let me know if you need clarification, am far from an excel guru!!
Thanks
E.
I have name and surname in one sheet(sheet 1), and name, surname, address and postcode in the other (sheet 2). Unfortunately I can't just sort, cut and paste because there is a high likelyhood of redundant data.
Now adding to that visual, Sheet 1 is actually 6 separate sheets (from 1st - 6th Grade for a school).
Can someone please give me some very plain English instructions on how to get the address and postcode from Sheet 2 to the other 6 sheets?
Please let me know if you need clarification, am far from an excel guru!!
Thanks
E.