Find, Copy, and Paste

**NSTurk725** · 11-17-2009, 06:22 PM

Hi, I am new to VBA and am trying to put together some code that will do the following:

Assuming I have the workbook "Results.xls" open (files are attached to thread):

(1) Search Column A on the worksheet "sampleData" in the closed workbook (testData.xls) for the string value "STS".

(2) When it finds the match, select Column C and copy the respective cell value

(3) Paste that copied data in Column D on the active worksheet "Summary" (within the workbook "Results.xls") in the respective row (from Column A) where it says "STS".

I have attached all the sample files I'd like to use to help illustrate my task

I understand this is pretty similar to a V-Lookup, but I would like to learn the VBA procedure to do this.

Thank you for any support provided.

**venkat1926** · 11-21-2009, 01:47 AM

if the testdata.xls is in closed workbook you have to use the path of this file.

you have to use something like this in the summary sheet summary in file results.xls

=VLOOKUP(A4,'C:\unzipped\nsturk725\[TestDATA.xls]sampleData'!$A$1:$C$17,3,FALSE)

in my computer the file testdata.xls is saved in the path
C:\unzipped\nsturk725\
you change this path to your path
remember the single apostrophe in the beginning and again at the end of the sheet name(sampledata) is required. and also exclamation mark(!).

Find, Copy, and Paste

LinkBack

Thread Tools

Rate This Thread

Display

Find, Copy, and Paste

Re: Find, Copy, and Paste

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions