Transfer from one sheet to another.

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
I have an Excel workbook that I need help with.
On sheet one I have a column with client's names (B6-B35, B37-B66).
On this same sheet I have a column for training (M6-M35, M37-M66).
There will be "Y" for yes, and "N" for no entered in this column.
When there is a Y entered in the training column I need for the client's name to be automatically entered into a column on another sheet.
This will be the training sheet and I need the client's name entered in C6-C29.
It does not need to do anything if N is entered in the training column.
I also need for the names to remain in the training column if the Y is changed to a N in the training column.
Thanks



1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Could you please upload a sample WORKBOOK file with sample data 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