Thankyou both very much for the advice. I have started to use the
vlookup function and it appears to be at least part of the way forward
for me.
There appears to be two problems still:
The vlookup function requires the input of the the cell "coordinates"
this would be very useable if all of the account numbers in the company
database were; 1, all ONLY numbers, and 2, an unbroken sequence of
numbers.
Also, it seems to require that I write a function each time I produce a
Jobcard, and I need to run several of them.
So, what I really need is a function that will search column A for a
given account number (which could be alpha, numeric, or alpha&numeric),
then insert the contents of some of the cells in the row of the "found"
account number into prescribed cells on a different page. The second
part of this appears to require the "linking" of several lookup
functions.
Please don't think I am feeble and am just scrounging information, I'm
not. I am keen to learn as much as I can about excel, and take the
information that you give me seriously, and am grateful for it too. :)
thankyou both again
regards
John
--
justjohn
------------------------------------------------------------------------
justjohn's Profile:
http://www.excelforum.com/member.php...o&userid=30663
View this thread:
http://www.excelforum.com/showthread...hreadid=507223