I want to see if this is possible.
I have data like this: there are 1000 rows like this and 17 sheets of this. If we gave access by mistake for all, or want to change an no access to a has access, i have to go into 17 sheets and locate the row and change. Could a macro do this based on the value of col a across all sheets? even to run manually in each sheet but better in one shot. i can change the search term each time. A prompt would be interesting to see but for this purpose its ok.
A B
History Inquiry No Access
PARI No Access
Management on Behalf of the Client Has Access
Management from the Client Has Access
Worker Travel Has Access
I have data like this: there are 1000 rows like this and 17 sheets of this. If we gave access by mistake for all, or want to change an no access to a has access, i have to go into 17 sheets and locate the row and change. Could a macro do this based on the value of col a across all sheets? even to run manually in each sheet but better in one shot. i can change the search term each time. A prompt would be interesting to see but for this purpose its ok.
A B
History Inquiry No Access
PARI No Access
Management on Behalf of the Client Has Access
Management from the Client Has Access
Worker Travel Has Access
Last edited:
