My problem is this, I have a spreadsheet that lists sales across 12
worksheets (Jan, Feb etc.) and within these worksheets i have 6 sales people
and details by line of their sale and profit etc. I want to create a new
workbook that has 6 worksheets (1 for each sales person) and if i type in the
name and or month into a given cell (i.e. A1 = name and C1 = month) i need
the information from the other sheet to be transferred automatically across.
To clarify, if i enter Bruce and Jan into two fields i need all entries in
workbook 1, in the tab for Jan and with the salesperson name of Bruce to
transfer over the names of the customers and the registration numbers and the
profit etc. to workbook 2.
If the command i need is vlookup i am in trouble because i have not got the
hang of vlookup yet (so a link to a good tutorial site would be very helpful.
Thanks very much in anticipation.