I understand that once a cell is highlighted you can drag it to populate the following cells. Is there a function that can do this automatically to the next populated cell? The reason being is that my report has hundreds of lines and its too time consuming doing this one name at a time.
What I have now
Name Grade Ted 3 3 3 Susan 4 3
What I want
Name Grade Ted 3 Ted 3 Ted 3 Susan 4 Susan 3
Thanks
Enter in D2 and copy down
Formula:
Please Login or Register to view this content.
Enter in E2 and copy down
Formula:Please Login or Register to view this content.
v A B C D E 1 Name Grade Name Grade 2 Ted 3 Ted 3 3 3 Ted 3 4 3 Ted 3 5 Susan 4 Susan 4 6 3 Susan 3 7
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thanks but is there any way to do this without having to create formulas or extra tables?
Last edited by yuenk; 11-15-2016 at 02:04 PM.
If formula is not an option you would have to look for a VBA solution.Originally Posted by yuenk
Hi there,
See if the following code does what you need:
The highlighted values may be altered to suit your own requirements.
Please Login or Register to view this content.
Hope this helps - please let me know how you get on.
Regards,
Greg M
Maybe:
Please Login or Register to view this content.
Thanks this works! This is simple enough too
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks