copy data from one worksheet to several worksheets

[mingee]

Hi,

I need to copy columns of data in one worksheet into several worksheets. I basically have about 10 columns of info that I'd like to copy into the other worksheets, but sometimes there are some in between columns that don't contain data that I'd like to skip. There are two ways that I need to identify the data by, the first column, which consits of dates, and the top rows, which will tell me which column i need to extract the data from. I've tried using the various lookup functions and they don't seem to work when i set the table array to the entire worksheet. Does anyone have any suggestions?

Thank you.
mingee

 

[Jon von der Heyden]

Hi Mingee, welcome to the board!

Could you post a sample of the spreadsheet using Colo's HTML Maker please?

From what I can gather you need an INDEX() function with nested MATCH() functions to plot the column index's and row index's. Did you try INDEX() with MATCH() before?

http://www.puremis.net/excel/downloads.shtml

 

[mingee]

options2.xls
	BU	BV	BW	BX	BY	BZ	CA	CB
1	BAC+VLEquity			BAC+VZEquity			BAC+VMEquity
2	Date	PxLast		Date	PxLast		Date	PxLast
3	10/4/2006	8.8		########	#N/AHistory		10/4/2006	11.6
4	10/3/2006	8.8					10/3/2006	11.6
5	10/2/2006	8.8					10/2/2006	11.6
6	9/29/2006	8.8					9/29/2006	11.6
7	9/28/2006	8.8					9/28/2006	11.6
8	9/27/2006	8.8					9/27/2006	11.6
9	9/26/2006	8.8					9/26/2006	11.6
10	9/25/2006	8.8					9/25/2006	13.8
11	9/22/2006	8.8					9/22/2006	13.8
12	9/21/2006	8.8					9/21/2006	13.8
13	9/20/2006	8.8					9/20/2006	13.8
14	9/19/2006	8.8					9/19/2006	13.8
15	9/18/2006	8.8					9/18/2006	13.8
16	9/15/2006	8.8					9/15/2006	13.8
17	9/14/2006	8.8					9/14/2006	13.8
18	9/13/2006	8.8					9/13/2006	13.8
BoA

As you can see, I just need to paste column bu, vb, and cb into the new worksheets. The top row serves as the identifier for the data.
And to answer your question, I haven't tried index() and match().

thanks for your help.