LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
davidthegolfer
 
Posts: n/a
Default Copy the formatting and content of a range


I wish to create a complex (pricelist) template which contains many
named ranges. When creating new individual price lists which contain
common ranges from the template, I need to select say range called
"Header" which is several columns wide and several rows high.
I need to find a way to copy & paste the formatting and content of a
range, preserving different row heights and column widths, together
with titles etc.
So far I haven't found a solution. Any help gratefully appreciated.
Thanks in advance.
Kind regards
David


--
davidthegolfer
------------------------------------------------------------------------
davidthegolfer's Profile: http://www.excelforum.com/member.php...o&userid=31806
View this thread: http://www.excelforum.com/showthread...hreadid=515286

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional cell background formatting, based on cell content nosivad Excel Discussion (Misc queries) 5 February 11th 06 11:12 PM
Creating links to cells with no content, but that have formatting cerah Excel Discussion (Misc queries) 1 January 24th 06 11:31 PM
replace one tag in content of one cell and format not changed replace one tag in content of one cell a Excel Discussion (Misc queries) 1 January 9th 06 03:36 PM
copying content of cell automatically to multiple cells PAUL GRAZIDE Excel Worksheet Functions 1 June 4th 05 06:52 PM
Sheet Protection -- Content vs. FORMATTING jayceejay New Users to Excel 1 March 29th 05 09:11 PM


All times are GMT +1. The time now is 02:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"