Hi, I have an excel workbook where I want to be able to enter information into one cell on a spreadsheet, and it will be repeated in another cell on a different spreadsheet. The spreadsheets are laid out differently. I already have used ='HDP map - control doc'!M12 to so that text is automatically updated. However there is a range of cells which I have put blocks of colors into them, to show which years activity will take place. In this case when I use the same method, all I get it a zero in that cell.
Is there a way of ensuring that everything will be shown in cell B, including formatting when I type into a cell A?