Hello,
Normally I can figure things out in Excel pretty well but this one has me right stumped. Not even sure if Excel can do it but it would be great if it could. I have three sheets in one Workbook 2 are data imported from a tracking program I use externally. Now my question is Can I have the first Workbook search for names in the other two and if it finds that name pull the data to a corresponding cell in the first book. I have attached an example this is a small sample size as the true one has a little over 500 lines to it.
I know I can do this manually but that is very administratively heavy and I am trying to reduce that, any help even the bad news that it cant be done would be appreciated.
Bookmarks