Create appendix

G

gav meredith

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

BrianB

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
 
Top