Copying data across different worksheets

There are two easy ways to do this. (1) Hover the mouse over the southeast
corner of the cell with the formula to be copied. When the white cross
changes to a black cross, depress the left mouse button and hold it down,
then drag down the column as far as you need. No problem if you go too far;
you can delete unneeded entries.

(2) Click on the cell with the formula to be copied. Holding down the shift
key, click on the last cell in the column that will contain a formula. All
the intermediate cells will then be selected (darkened). Press Ctrl+D to
fill down.

You can also perform these procedures from left to right. To fill right,
press Ctrl+R.

"Nic M" <Nic.M.27i6an_1147115401.6067@excelforum-nospam.com> wrote in
message news:Nic.M.27i6an_1147115401.6067@excelforum-nospam.com...
>
> Hi everyone
> I imagine there is a really simple answer for what I am trying to do so
> I'd be grateful if someone could take the time to point me towards it.
> As an excel baby I don't know the language to use to describe what I'm
> trying to do in 'Help' or when searching through other users questions
> so apologies if my request duplicates any that have gone before.
>
> So.... what am I trying to do?
> In worksheet A (sources) i have a list of foods in column A and and I
> want all current and future entries to copy to column A in worksheet B
> (symptoms). The formula I am using for this is fine (='sources'!$a$5)
> but I don't know how to set it up so that the formula duplicates all the
> way down the equivalent column in worksheet B. At the moment I am
> copying the formula from row 5, pasting to row 6 and editing the
> formula to $6. I'll lose the will to live if I have to do this
> individually and I'm sure there has to be a better way judging by all
> the really advanced stuff people are talking about on this forum An
> answer that involves simple editing or formating would be much
> appreciated as the things I've seen in other posts about code is like
> reading Japanese!
>
> Many thanks
> Nic, UK
>
>
> --
> Nic M
> ------------------------------------------------------------------------
> Nic M's Profile:
> http://www.excelforum.com/member.php...o&userid=34246
> View this thread: http://www.excelforum.com/showthread...hreadid=539973
>

Works a treat and so simply explained.
Much appreciated
Nic