maybe this wish exists in other variations already, but I would really wish for a search and replace function in worksheets. I had to create a tone of worksheets recently for a list of apartments in different buildings. I created a template and than had to duplicate them for each building and than adjust the building name in the search criteria manually in each worksheet multiple times. That can easily add up to a hundred operations i have to perform. Maybe I am to ignorant and an easier way exist but so far i couldn't find it. I've attached a screenshot of my problem and wish for a necessary function.
Btw. could we also have an easier way of choosing between OR and AND in the criteria dialog box. Having to manually adjust that is a pain in the neck atm and very prone to mistakes.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
elepp
Hi folks,
maybe this wish exists in other variations already, but I would really wish for a search and replace function in worksheets. I had to create a tone of worksheets recently for a list of apartments in different buildings. I created a template and than had to duplicate them for each building and than adjust the building name in the search criteria manually in each worksheet multiple times. That can easily add up to a hundred operations i have to perform. Maybe I am to ignorant and an easier way exist but so far i couldn't find it. I've attached a screenshot of my problem and wish for a necessary function.
Btw. could we also have an easier way of choosing between OR and AND in the criteria dialog box. Having to manually adjust that is a pain in the neck atm and very prone to mistakes.
Regards,
Eddi
Link to comment
4 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.