How do I mirror cells?

shabbaranks · #1 09-13-2011, 04:20 AM

Hi All,

Im trying to mirror cells within a spread sheet, and currently have =sheetnumber!cellnumber.

The cell format doesnt copy over and also if the cell is blank it puts a 0 in the copied sheets cell. Is there a better way of doing this please - and if so how?

Thanks

OTPM · #2 09-13-2011, 04:41 AM

Hi
Your formula is fine. However you will need to make sure the format of the cells between the target and source sheets are the same. You could do this by copying the source sheet and then deleting all the values in the new sheet initially and then entering your formulae.
In order to stop displaying "0" if the source cell is empty simply click on the Tools Menu and select Options and untick the "Zero Values" box.
Good luck.
Tony(OTPM)

shabbaranks · #3 09-13-2011, 04:58 AM

Thanks that worked a treat

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
A macro to mirror the movement of the cursor	ACA	Word VBA	0	08-24-2010 03:21 PM
How to Count from Different Cells?	Shahzad	Excel	3	06-26-2010 01:06 AM
Count range cells eliminating merge cells	danbenedek	Excel	0	06-15-2010 12:40 AM
Mirror text in Word	sports96	Word	3	03-09-2010 10:37 AM
Display the cells which add up to a certain sum	edbyford	Excel	1	11-26-2009 01:30 PM