Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-04-2017, 01:24 PM
cloudforgiven cloudforgiven is offline How to copy excel sheet withe HEADER and Paste into new sheet? Windows XP How to copy excel sheet withe HEADER and Paste into new sheet? Office 2013
Novice
How to copy excel sheet withe HEADER and Paste into new sheet?
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to copy excel sheet withe HEADER and Paste into new sheet? Open an existing sheet by clicking on a cell in a master sheet darbybrown Excel 3 09-12-2016 05:12 PM
Populate sheet 3 with data from sheet 1 and sheet 2 speck Excel Programming 0 01-14-2015 07:54 AM
How to copy excel sheet withe HEADER and Paste into new sheet? Create a New Sheet from Existing Sheet with Specific Columns malam Excel Programming 1 10-17-2014 10:01 PM
How to copy excel sheet withe HEADER and Paste into new sheet? Search Multiple strings and create new word sheet subodhgupta Word Tables 1 05-20-2014 08:09 AM
Search for date and then apply mutliple search criteria in huge dataset maxtymo Excel 2 12-01-2013 04:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:05 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft