Peter,

I created multiple files (10 in all) dealing with various aspects of my
budget. On my main budget program, I have a sheet that lists information
from the other sheets. Although I was able to €œlink€� a cell to another
particular cell from another sheet, I wasnt able to €œlink€� that cells
format. No biggie though, for on the main sheet I changed the format to the
€œlinked€� cell and no problems. Sounds complicated, but was EXTREMELY easy (I
only needed to format the cell that I was working on one time).

"Peter Wells" wrote:

I'm building a spreadsheet that sums results from a number of other
spreadsheets, my question is how to keep both the data and formatting
synchronized. I've tried using a formula in the destination file to
reference the source and importing with a query - both handle the data values
just fine but do not seem to handle formating, such as font color.

What is the best technique?

Thanks in advance,

Peter