Hi. I have a table that will continually expand as new rows are added (thanks to a preceding macro).
Each row has a range of cells with data and formula in them ($B17:$K17), but I I want to have a button (or double-click cell) in $L17 that calls a follow on macro.
When I click that button I want to copy and paste an existing worksheet (called 'copythissheet') but have the cells that are immediately to the left of the button (i.e. $B17:$K17) copied and transposed into the Range ($B2:B11) on the new versions of the copied worksheet.
I would paste some code but it's pretty messy and I think it'd be better to start afresh.
Thanks
Each row has a range of cells with data and formula in them ($B17:$K17), but I I want to have a button (or double-click cell) in $L17 that calls a follow on macro.
When I click that button I want to copy and paste an existing worksheet (called 'copythissheet') but have the cells that are immediately to the left of the button (i.e. $B17:$K17) copied and transposed into the Range ($B2:B11) on the new versions of the copied worksheet.
I would paste some code but it's pretty messy and I think it'd be better to start afresh.
Thanks