Johnromita
New Member
- Joined
- Apr 28, 2002
- Messages
- 3
Hi, can anybody help me out?
I have several different workbooks, I want to create a new one which displays certain stats from the others. I've tried linking the source straight from the dependent, but all the formatting (merged cells and colours) is lost when this happens. The data is basically a calender, with merged cells indicating promotions over a period of time. As such, it's vital to keep the formatting as I compare the data in the new sheet. (I'm using the "paste special" "paste link" command. (Excel 2000)
Thanks in advance,
John.
I have several different workbooks, I want to create a new one which displays certain stats from the others. I've tried linking the source straight from the dependent, but all the formatting (merged cells and colours) is lost when this happens. The data is basically a calender, with merged cells indicating promotions over a period of time. As such, it's vital to keep the formatting as I compare the data in the new sheet. (I'm using the "paste special" "paste link" command. (Excel 2000)
Thanks in advance,
John.