I'm trying to have it so when a specific cell is filled out with specific text it runs a specific macro. This macro populates a specific range of cells relative to the text cell (example cell A1)
so:
IF
A1="text1"
THEN
Execute 'Macro1' (which fills range C1:D5)
I also want to be able to set other possible text values to run other macros, example: text2 runs macro2, text3 runs macro3, etc.
In a nutshell:
If trigger text in A1 is typed, Macro will run and paste specific range of text in C1:D5
Now I need this to be relative, so if this same text is typed in A10, for example, the macro will now populate C10:D15
Or perhaps there's a way to do this without macros, as each of the desired "paste" items have named ranges.
Thanks!
Bookmarks