Copying data

[Andre]

Hi



How do I set up a drop down list (Sales April, May, June ect) to copy data
from 1 column to another in a specified location?



Thanks



Andre

 

[Debra Dalgleish]

You can use and Advanced Filter to copy data from one location to
another. There are instructions in Excel's Help, and here:

http://www.contextures.com/xladvfilter01.html

Also, there are sample files here that use Data Validation to create
dropdown lists, and Advanced Filter to extract data:

http://www.contextures.com/excelfiles.html

Under Filters, look for 'Product List by Category '

 

[Andre]

Debra

Thanks for your help on this but I think I am trying to over complicate
things. Would it be possable for me to email the spreadsheet for someone to
look at and point me in the right direction. Or is that not the done thing.

Regards

Andre

 

[Debra Dalgleish]

Probably someone could help you, without you mailing the spreadsheet, if
you can give a bit more detail about what you're trying to do.