Solved: Copy/Paste cells into new sheet based on value list in 3rd sheet

[LLEW1]

Hi,

looking to Cut/Copy cells from Sheet1 into Sheet2 based on names a single colum list (which will change over time) in Sheet3.

Appreciate any vb code suggestions...

[MaximS]

sample worksheet will help to do it quicker otherwise is pure guessing what exactly you need

[LLEW1]

Hi MaximS,

have attached simplified workbook (Excel 2007) (ControlSubSet.xlsx) as sample of data.

Actual data deals with hundreds of rows, and so in solution will be looking to read entire range in the "Names" column of the "Data" tab, looking for names listed in the "Control" tab.

Hope this helps explain what Im after - thanks for help - much appreciated.

LLEW1

[MaximS]

hi

check attachment for details, i have added some extra records to stress it a bit (around 60k) and it dit the job in less than minute. I had to remove it due to file size.

[LLEW1]

Thanks MaximS - thats perfect; really very appreciative of your help with this.

Enjoy your day.