Using TopLeft of a button to reference a range of cells and CopyPaste them to a new worksheet

gussio

New Member
Joined
Mar 4, 2016
Messages
2
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
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Watch MrExcel Video

Forum statistics

Threads
1,108,579
Messages
5,523,700
Members
409,532
Latest member
Lmfacc

This Week's Hot Topics

Top