Hello, i want to print ID card of all members whos data is entering in Sheet1 i have formated sheet2 so i want data which i enter in sheet one each line should come in sheet 2 individually so that i can print cards from formated sheet2. below examples
Sheet1
Name Company name Mobile Number
XYZ asfdsdf 30439403
ZZZ werwesf 242314234
ABC asdfwerqwer 9889863
when i type xyz next sheet should also take xyz and i will take print, again when i type zzz sheet2 should take only zzz not above line xyz
Sheet2
Name Company name Mobile Number
XYZ asfdsdf 30439403
it should come like this, than i can take id print out again when in sheet1 i enter next row it should come only next row but not first one. please help