Hi
I need to be able to put X into column A on worksheet one (list) and have the information on that line copy into worksheet 2 (Card). However if i change the X to another line e.g. from 4 to 2 i need the information on line 2 to appear in worksheet 2 (card) instead. I have tried various IF formulas but cant seem to get it to work. Attached is a copy of the workbook
Please help ! Thank you for your time
Bookmarks