How to copy excel sheet withe HEADER and Paste into new sheet?
Hi I have a table in one sheet(see attachment), and I want to use a button to copy the entire SHEET from that to another sheet. How would I do that? Its for people who are very old I want to make them avoid copying and pasting. I tried doing it but only the table contents get moved over, no lines nor the header. Also I tried recording a macro but it still wont work properly? Any ideas?
Last edited by cloudforgiven; 01-04-2017 at 09:04 PM.
|