Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-20-2014, 11:31 PM
excelledsoftware excelledsoftware is offline Transferring info from 1column on sheet2 to sheet1 Windows 7 64bit Transferring info from 1column on sheet2 to sheet1 Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

Ok here is my suggestion for what you are trying to do. Normally I would write a VBA script to do this but it is very possible to do with formulas as well.

1: I would change where you create the search name into column A on Sheet2. This makes it alot easier to use it for vlookups. You can still easily copy and paste new data in the sheet just start on Column B.
2: I would change your search name formula to the following
Code:
=SUBSTITUTE(LEFT(C2,FIND(",",C2)-1)," ","")
This removes the spaces which have been problematic the only thing to watch out for is duplicate first and last names.
3: Use the following Vlookup formula in Column I for Sheet1
Code:
=VLOOKUP(B4&A4,Sheet2!A:D,4,0)
With these changes this should work except for the names that have the dreaded * in them. This will need to be removed and a Find and Replace can be problematic with removing * because it is considered a wildcard.



If this still isnt quite what you are looking for maybe we should look into writing you a VBA script that will do this task automatically.

Let me know

Thanks
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Newbie to excel for starters, needing to transfer info from sheet2 to universe sheet. rogcar75 Excel 0 08-12-2014 07:21 AM
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 bobznkazoo Excel 2 03-27-2014 11:14 AM
split text files to worksheets (sheet1,sheet2,sheet3 soon sheet 25) gsrikanth Excel Programming 1 03-22-2012 11:04 PM
Transferring info from 1column on sheet2 to sheet1 arrows remain between task bars, but predecessor info disappears from task info Antares Project 1 12-14-2011 09:19 AM
Transferring info from 1column on sheet2 to sheet1 How to merge two cells from sheet1 to one cell in sheet2 in next sheet KIM SOLIS Excel 6 10-30-2011 11:14 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:53 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft