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
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