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!!!!

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