Transferring info from 1column on sheet2 to sheet1

excelledsoftware · #1 08-26-2014, 05:07 PM

No problem ask away.

so you would change the vlookup on your first sheet to include all of the searchstring. Based off of the example you provided the formula would be something like

Code:

=VLOOKUP(A9&B9&"_"&E9&" "&F9,'Data Scrape'!C:O,13,0)

You need to get the first part of the vlookup to equal what the search string is. Once you get it to work you shouldnt need to update it again and when you run the script it will pull in this new formula. If that dosnt quite make sense PM me and well get it all sorted out.

Thanks

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
arrows remain between task bars, but predecessor info disappears from task info	Antares	Project	1	12-14-2011 09:19 AM
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