Automatically paste copied data
Dear friends,
I get 500+ daily sms containing details such as patient name, date, department. i have to arrange these details in excel sheet.
The best way i think is to get data in text to column in excel and then extract required data as shown in figure below:
All i need is a VBA code in which when i copy some consecutive cells data from original sheet it get pasted in other sheet at the active cell and upon pasting, next right cell is selected.
Thanks.Untitled.png
Hi,
Try this code. Add in a keyboard shortcut and then highlight the cells that you want copied and run the macro using the keyboard shortcut each time (starting with referred by, then date, then department)
Please Login or Register to view this content.
Regards,
Stephen
If you feel someone has helped you please thank them and click on the star on their post to add reputation.
Please ensure that you use code tags where relevant, and mark solved threads as solved.
Most of all please be respectful and understanding of others.
Woooooooowwww...... Working just perfect.... Thanx a lot...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks