Hi,

I have several spreadsheets where I import data using macros into a series
of tables. Several operations are then performed on the data. The new
outputs plus some of original inputs are then transferred into another set of
tables using match index vlookup etc formulas where they are then re-ordered
and grouped.

By using the macro I copy the data into table set 1, along with the formats
as per original. For example line 1 has red bold text in all cells and the
second line has a green filling in the cells. I will see the red bold and
filling in table set 1.

Table set two will then re-arrange the data from set 1 using the search
functions but it cannot copy the formats.

Is there a way of getting the search function to copy formats as well as
contents?

Thanks
LiAD