Eloise T
Active Member
Please see the two attachments, Demo-1 and Demo-2. I have six Name Manager formulas in Demo-1. When I try to copy a single row (Columns E through F) from file Demo-2 to file Demo-1, I see: Note: SearchFor70
If I click either [Yes] OR [Yes to All] I see: Note: SearchFor75, then Searchfor80, then SearchFor84, SearchFor85, and finally SearchFor90.
In other words, [Yes to All] doesn't work and satisfy all six Name Manager formulas. So I have to click 6 times vs. just once for every single
line I add...something I'm doing for hours each day. In case it matters, I'm using Excel 2016 with Windows 7 Professional.
Please, can anyone tell me why [Yes to All] doesn't work?
If I click either [Yes] OR [Yes to All] I see: Note: SearchFor75, then Searchfor80, then SearchFor84, SearchFor85, and finally SearchFor90.
In other words, [Yes to All] doesn't work and satisfy all six Name Manager formulas. So I have to click 6 times vs. just once for every single
line I add...something I'm doing for hours each day. In case it matters, I'm using Excel 2016 with Windows 7 Professional.
Please, can anyone tell me why [Yes to All] doesn't work?