Cell data remains permnent
Dear all,
i have some data of 300 students,i needs your help in their data entry as if i enter their details in sheet1 column wise in a2,a3,a4,a5,a6,a7,a8 it should be appear in sheet2 row wise as a2,b2,c2,d2,e2,f2. if i delete sheet 1 data to enter next student already entered sheet2 data remains there and the new student details appears in the next row....
please any one help..
advance regards
This is not possible with formulas, you will need VBA for this.
Also, this thread is marked as SOLVED. If this is not the case, please use the thread tools to remove that status
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks