PDA

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



LLEW1
02-20-2009, 04:55 PM
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...:doh:

MaximS
02-20-2009, 09:26 PM
sample worksheet will help to do it quicker otherwise is pure guessing what exactly you need

LLEW1
02-20-2009, 09:50 PM
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
02-21-2009, 06:05 AM
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
02-21-2009, 04:34 PM
Thanks MaximS - thats perfect; really very appreciative of your help with this.

Enjoy your day.