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