Hey all, I have a fairly large valuation worksheet, and I would like to repeat columns A&B on the left side of every page BUT page 20 (my setup is basically 10 'rows' of pages by 2 'columns' of pages).. Is there any way to do this?
This may not be what you are asking for, but it is still a neat trick. Copy the range then select the sheet tab you want to paste it into first. However instead of pasting the range into that sheet hold down the Ctrl button and select all the tabs of the sheets you would like to paste the range into. Now on the sheet that you have displayed paste or paste special into the cell of your choosing. The pasted range should be in every sheet now. To release the tabs just choose the tab of the sheet you copied from.