• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Name Loop? Assistance, please!

ExcelGuru516
As written in #24 reply.
One sample attached by 'my way'
... others could do this other way too!
 

Attachments

  • NameCopyVletm.xlsb
    101.9 KB · Views: 2
Last edited:
Like vletm yet wrote, your Sheet2 results can be achieved without the first step.​
As on my side this first step takes less than 0,3s …​
It depends also if you use Sheet1 for anything else and if your Sheet2 attachment is really the final step …​
 
For who knows a bit Excel, removing the blanks rows, filling the names in first column then copying data to Sheet2​
if dates difference is greater than 9 days needs a minute to operate manually, a very beginner may need one minute more​
and thus just using EZ Excel Basics, so faster than creating any code if it's for an unique task !​
A VBA procedure reproducing the same way runs in less than half of a second …​
Another way than copying data to Sheet2 is applying conditional formatting directly in column B of Sheet1.​
 
Back
Top