cloneing cells in different worksheets

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


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?action=getinfo&userid=30245
View this thread: http://www.excelforum.com/showthread.php?threadid=499163

.

Relevant Pages

  • Re: Cell References
    ... > I have 2 separate work sheets. ... > sheet A to cells in Work sheet B. The values in A are separated by at ... Hi Gman ...
    (microsoft.public.excel.misc)
  • RE: Macros to count cells with specific color and text
    ... Mike's code will work OK if your color is set by regular format. ... colored cells is not a very reliable procedure. ... I have two work sheets in an excel document. ... I need this to make my documentation work easy. ...
    (microsoft.public.excel.programming)
  • Re: copy, paste and transpose formulas into work sheets
    ... Assuming that you mean you want cells A1:M1 of Sheet1 to appear as cells ... same headings etc. ... corresponding headings and data in the slave work sheets need to ... change automatically along with the prime sheet. ...
    (microsoft.public.excel.worksheet.functions)
  • #REF!, TRUE or FALSE
    ... Im working on a worksheet where i wanna check cells in two other types ... of work sheets but but only one of the exists for each number. ...
    (microsoft.public.excel.worksheet.functions)
  • Setting values for "TRUE","FALSE" and "#REF!"
    ... Im working on a worksheet where i wanna check cells in two other types ... of work sheets but but only one of the exists for each number. ...
    (microsoft.public.excel.programming)