View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cody
 
Posts: n/a
Default Transfer data from one sheet to another

Did I stump you guys? This is a hard one!

Here is the senario:

Worksheet one has a cell with a drop down menu with the numbers 1-10 in it.
Below the drop down menu are two columns labled 'account number' and 'method'
each with many fields available for info below them.

Worksheet 2 is a database. It has many columns labled 'account number', '
method', 'date', 'cycle' etc. The cycle field is what contains the numbers
1-10 of the previous worksheet.

I need a way of making it so that when I choose 1-10 from the dropdown menu
on the first sheet, that it reads the 'cycle' list from the second sheet and
finds all that match and then transfers the 'account number' and 'method' of
the ones that match back to the first sheet and places them in the
appropriate columns. This is a hard one and any suggestions are so very much
appreciated.
--
Cody