find and copy cells to different workbook
I have two workbooks,
book1 has col b with names, over 200 and growing.
book2 has multi sheets (different citys) with names, locations, ID,
other info
I need for ever name (200+ names) on book1
goto book2 find the name on any sheet
go down two cells and return value to book1 in col C
down one cell and return value to book1 in col D
down three cells and return vaule to book1 in col E
book1 before
ron
debbie
book1 after
ron dallas 5795664 on-site
debbie Austin 345923 tel-com
I know I am making this harder than it should be, but could use some
directions.
Thanks,
ron
|