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.
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
