Forum Discussion

Jane Sculley's avatar
Jane Sculley
Copper Contributor
Feb 08, 2018

copy data from one workbook to another but in different sheet?

The problem is I do not want to create a filter because sometimes there will be a manual entry. This a log for transportation and we have dedicated drivers and OTR drivers, would like to import the dedicated information without creating a filter because we have non-dedicated drivers that will have to entered manually.  

can you help me

  • Jane Sculley's avatar
    Jane Sculley
    Copper Contributor

    I creating a drop down list and want to enter information that is not on the list? shows a option (ignore Blank) so I tried to see if it would let me enter another name that is not on the list and it will not allow me. The drop down list has dedicated drivers on it( a lot of them) however there are some that are not regular drivers and would have to enter their name in. shows a option (ignore Blank) so I tried to see if it would let me enter another name that is not on the list and it will not allow me. Can you help me what I need to do?? I Have 50 drivers names in the system I have use all the time but I will need to add ones that are not in the system. can someone help what I need to add to the spreadsheet to create this list.

    thank you for your help,

    Jane

Resources