Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 54
Default Create appendix

Hi, i have an exisiting code that copies and pastes data within cells based
upon a numerical value 1. What i am after now is to have a section of a
worksheet (A1 D20) either attach to another worksheet as an appendix or
have the data paste into a section of another worksheet. Problem with the
latter is the formatting of the cells is different so i would assume
inserting the data as an appendix would be a better option.

Any suggestions would be extremely helpful!!!!!

Thank you!!!!


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Create appendix

If the data to be transferred is in a suitable block then I would us
Paste or Paste Special depending on whether I wanted to transfer th
formats or not. This is faster than a cell by cell approach

--
Message posted from http://www.ExcelForum.com

Reply
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
insert an Excel spreadsheet as an appendix in a Word Document Ginni Excel Discussion (Misc queries) 2 April 14th 23 05:33 PM
Create a macro to create excel line graph with coloured pointers anddata lables anuj datta Charts and Charting in Excel 1 September 30th 09 04:04 PM
How to create adress list so can mail merge and create labels? adecocq Excel Discussion (Misc queries) 2 October 25th 06 12:32 AM
how to add excel sheet in word document as an appendix hello New Users to Excel 0 September 20th 06 04:28 PM
Create dictionary of terms, create first time user site Solitaire Jane Austin New Users to Excel 1 January 19th 06 09:47 PM


All times are GMT +1. The time now is 05:15 PM.

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

About Us

"It's about Microsoft Excel"