working on two worksheets i have a need to reproduce numeric information
into cells that are not in identical cells on both work sheets as i am
able to do this

example: I want to show the same information in two cells one being on
worksheet 1 d5 and the other being on worksheet 2 b6 (for this example
the source uninportant) its the mechanics that are inportant

i can copy paste it over or any of the other copy paste procedures but
this is to long winded as in the end there will be loads of cloned
cells cant seem to find the informatiion on how to do this ,

step by step would be very handy

regs kev


--
kevatt
------------------------------------------------------------------------
kevatt's Profile: http://www.excelforum.com/member.php...o&userid=30245
View this thread: http://www.excelforum.com/showthread...hreadid=499163