samedi 28 février 2015

how can we access name from shet1 to sheet2 with leaving few lines in shee2 with blank space on sheet2

Will you please help me how can i access the name from one sheet to another sheet . the main thing is when i call the data from (sheet1!A1) after that 14 row should be blank in sheet 2. and on the row 15 of sheet 2 should store ( sheet1! A2) data. I have created such type of format on Sheet2


NAME :- Rozer 1 Roll-no 801


14 time blank line after that


NAME :- Sammul Roll-no 802


}}}}


All information are accessing from sheet1 . i want if i enter the data in sheet one, then sheet 2 automatically create such type of forms.I hope you will suggest me the best formula.The main problem arising in ( NAME & Roll-No ) column. Thank you !


Aucun commentaire:

Enregistrer un commentaire