Formula to dup information between sheets

Closed
Mel - 25 Jun 2010 à 10:03
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 25 Jun 2010 à 15:32
Hello,

I want to be able to type information into one sheet in an excel doccument and then based on the information i input into column E have it transfered to either sheet 2, 3, or 4.

to make it more clear i want to make a master database (sheet 1) and then have it sort the information based on the three possible opions i type into column E of sheet 1 and take that entire row of information and input it into either sheet 2, 3, or 4.

Hopefully you can help.

Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
25 Jun 2010 à 15:32
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too