Hello. I was wondering if a find and replace macro would be able to find the first name in the player column and replace all the 1's in the round rows and repeat the function for the rest of the player names.
Hello. I was wondering if a find and replace macro would be able to find the first name in the player column and replace all the 1's in the round rows and repeat the function for the rest of the player names.
Are you still using Excel 2010?
If you want to replace all the 1s. then jjust select B2 to K21 and use Find & Replace. No need for a macro, surely???
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Please Login or Register to view this content.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thanks for the prompt reply. I'm very inexperienced with the use of macros. How do I apply your attachments?
Post your workbook and I will add the code and a "run" button to call the macro.
See yellow banner at top of page for instructions.
See here
https://spreadsheeto.com/vba-editor/
Last edited by JohnTopley; 11-05-2023 at 11:40 AM.
Thanks again for your help.
ph1l,
for the workbook you uploaded in #6,
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks