I have a spreadsheet which currently uses a LOOKUP to obtain some values and also uses formula (eg SUMS).
What I need to do is hard-code the LOOKUP values (copy/paste special) but leave the SUMS. Within each sheet I have multiple selections so paste special cannot be used
I also have a number of sheets so am looking to automate this if possible as selecting each section on each sheet will be time-consuming?
Is there a way of selecting all cells with "LOOKUP" and pasting values, the sheets are all the same if this helps?
What I need to do is hard-code the LOOKUP values (copy/paste special) but leave the SUMS. Within each sheet I have multiple selections so paste special cannot be used
I also have a number of sheets so am looking to automate this if possible as selecting each section on each sheet will be time-consuming?
Is there a way of selecting all cells with "LOOKUP" and pasting values, the sheets are all the same if this helps?