Hi,
Seen many threads on this with specific examples relating to posters data sheet e.g. specific range and required formula.
I want a macro button that fills down to last row regardless of what spreadsheet I'm in? So enter formula in for example (filtered list) A2 wish to then press a button which copies it down from A3 onwards. Either by dropping into A3 and triggering hotkey or after keyed formula in A2. However, dont want the code to ref A2 or A3 but be dynamic based on selection etc.
Many Thanks
Gareth
Seen many threads on this with specific examples relating to posters data sheet e.g. specific range and required formula.
I want a macro button that fills down to last row regardless of what spreadsheet I'm in? So enter formula in for example (filtered list) A2 wish to then press a button which copies it down from A3 onwards. Either by dropping into A3 and triggering hotkey or after keyed formula in A2. However, dont want the code to ref A2 or A3 but be dynamic based on selection etc.
Many Thanks
Gareth