copy data from one worksheet to several worksheets

mingee

New Member
Joined
Oct 4, 2006
Messages
27
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
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Jon von der Heyden

MrExcel MVP, Moderator
Joined
Apr 6, 2004
Messages
10,808
Office Version
  1. 365
Platform
  1. Windows
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

New Member
Joined
Oct 4, 2006
Messages
27
options2.xls
BUBVBWBXBYBZCACB
1BAC+VLEquityBAC+VZEquityBAC+VMEquity
2DatePxLastDatePxLastDatePxLast
310/4/20068.8#########N/AHistory10/4/200611.6
410/3/20068.810/3/200611.6
510/2/20068.810/2/200611.6
69/29/20068.89/29/200611.6
79/28/20068.89/28/200611.6
89/27/20068.89/27/200611.6
99/26/20068.89/26/200611.6
109/25/20068.89/25/200613.8
119/22/20068.89/22/200613.8
129/21/20068.89/21/200613.8
139/20/20068.89/20/200613.8
149/19/20068.89/19/200613.8
159/18/20068.89/18/200613.8
169/15/20068.89/15/200613.8
179/14/20068.89/14/200613.8
189/13/20068.89/13/200613.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.
 

Forum statistics

Threads
1,136,612
Messages
5,676,800
Members
419,651
Latest member
alexanderguhr

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top