Formula to dup information between sheets

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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