Home » Blogs » johnrgeddes's blog

Automating transfer of seledted data from one sheet to another in excel 2003

Submitted by johnrgeddes on 1 December, 2014 - 21:38

I have many rows of data in sheet 2 of the workbook which is made up of 4 columns of text and numerical data.
What I would like is for the operator to select a record using a drop-down menu in a cell and all of the data appertaing to that record be copied onto sheet 1, is this possible?

»