Formula to dup information between sheets
Closed
Mel
-
Jun 25, 2010 at 10:03 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 25, 2010 at 03:32 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 25, 2010 at 03:32 PM
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.
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:
- Formula to dup information between sheets
- Sheets right to left - Guide
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Credit summation formula - Guide
- Excel grade formula - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 25, 2010 at 03:32 PM
Jun 25, 2010 at 03:32 PM
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