View Single Post
 
Old 01-04-2017, 01:24 PM
cloudforgiven cloudforgiven is offline Windows XP Office 2013
Novice
 
Join Date: Nov 2016
Posts: 13
cloudforgiven is on a distinguished road
Default 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?
Attached Files
File Type: xlsx test.xlsx (11.7 KB, 11 views)

Last edited by cloudforgiven; 01-04-2017 at 09:04 PM.
Reply With Quote