Hi Alan.. outstanding.. so simple and logical.. as well as useful. I followed along with your instructions and created the functionality in my own worksheet and then stepped through with F8. Good tip on using the Locals Window to watch the variables. I've always just hovered the pointer over the code. Locals is much easier to follow and track. I want to be able to build this one by memory, so will re-create it several more times to lock it in. Excellent tutorial and explanation. Thanks and Thumbs up!
Hi Alan.. been playing with your macro.. added Sheets(1).Select at the end to throw the user to the head of the list of sheets on completion. Also, added Application.ScreenUpdating = False at the beginning and True at the end to speed it up a bit for workbooks with many sheets. Realized I could change the ">" to "
I am an absolute idiot when it comes to this - I have never used a macro and have an incredibly basic understanding of formulas in excel... but I was able to follow along and do this. Thank you!
absolutely great video. Thank you!
Thank you for this video, short and concise. The only changed I made was to sort in descending order and it worked perfectly. Thank you!
Excellent! You're very welcome, Arden.
Hi Alan.. outstanding.. so simple and logical.. as well as useful. I followed along with your instructions and created the functionality in my own worksheet and then stepped through with F8. Good tip on using the Locals Window to watch the variables. I've always just hovered the pointer over the code. Locals is much easier to follow and track. I want to be able to build this one by memory, so will re-create it several more times to lock it in. Excellent tutorial and explanation. Thanks and Thumbs up!
Hi Alan.. been playing with your macro.. added Sheets(1).Select at the end to throw the user to the head of the list of sheets on completion. Also, added Application.ScreenUpdating = False at the beginning and True at the end to speed it up a bit for workbooks with many sheets. Realized I could change the ">" to "
Excellent work Wayne.
I like your English and your accent. Love to see more n more videos. Please upload videos on Primavera P6 .
Thanks Gopala.
CLEAR AND SIMPLE
Great!! Thank you Irere.
Nice one Alan
Thank you Glenn.
I am an absolute idiot when it comes to this - I have never used a macro and have an incredibly basic understanding of formulas in excel... but I was able to follow along and do this. Thank you!
That is excellent to hear 😊 Thank you.
If the sheets names were only numbers, will the code still work?
Yes I believe so. One way to find out.