Retaining formatting in workbook

D

danison

Hi

I am sure there is an easy way to do this but cannot figure it out.
have a workbook with columns that are colour patterned and hav
borders.

I want to cut and paste from another workbook (just a plain sheet), ye
do not want to do 'paste special, values' every time to preserve th
formatting in the columns of my receiving workbook. At the moment if
just do a cut and paste I loose the formatting in the column.

Is there an easy way around this?

Thanks

Bil
 
D

Dave O

If you'll right click on the tab name at the bottom of the screen,
click "Move or Copy", select the "Create a copy" option, and choose a
location for it among the existing tabs. This feature also lets you
copy the tab to a different workbook.
 
D

danison

Sorry, don't think I have made it clear enough. I am not looking t
create a copy of a worksheet. What I want to do is to copy a column o
text entries from another workbook and paste them into a specifi
column of a designated workbook, in which I perform a macro function o
the newly pasted entries.

The macro references a specific column in this designated workboo
where I paste the entries from the original workbook.

The problem is that the column in the 'macro' workbook is coloured wit
a pattern and has a border around it. The idea is that this is th
'model' file I use to perform the macro function on the newly paste
text entries.

It all works macro wise, however the only problem I am having is tha
when I copy & paste text entries from another workbook into the patter
column of the macro model workbook, I lose all the formatting of th
column in the macro workbook.

Of course I can choose paste special, values and retain the colum
formatting in the macro workbook. The problem is I am doing potentiall
hundreds of this action and it would be a lot better if I could simpl
go to the original file with text entries, copy, select the column o
the macro workbook, choose paste, and all the formatting in the macr
workbook column remains the same.


Any thoughts?

Thanks

Bil
 
D

Dave O

Thanks for clarifying. The trick is to get the information
transferred into the macro workbook without losing the format.

What would happen if the macro workbook referred to the text workbook
using formulas? (So the formula would look like: =[c:\my
documents\text workbook.xls]sheet1!'A1)

Staying with the formula idea, you might alter the macro so it takes
the formula value of each cell, converts it to a value and works with
it- sort of like doing a paste as values for each cell.

Or, going with the "paste as values from the text workbook" idea, you
might alter the macro to reinstate the formatting as it processes the
data.

I'm happy to discuss further: please email me directly,
[email protected].
 
Top