jumbel
08-26-2008, 05:34 AM
Hi,
I am having a macro which gets the data from several excel files and displays in one worksheet.
Now, I want to add few columns from other excel files in the resulting sheet without disturbing the order of the rows or columns. I am unable to add the data from other excel files.
Say I have two excel workbooks A and B with two worksheets 1 and 2. When I run the macro, a new sheet has to be displayed in the WorkBook A. I would like to display a new column in the resulting worksheet. The column should be added at a specified area not at the beginning ot the ending.
I am having a macro which gets the data from several excel files and displays in one worksheet.
Now, I want to add few columns from other excel files in the resulting sheet without disturbing the order of the rows or columns. I am unable to add the data from other excel files.
Say I have two excel workbooks A and B with two worksheets 1 and 2. When I run the macro, a new sheet has to be displayed in the WorkBook A. I would like to display a new column in the resulting worksheet. The column should be added at a specified area not at the beginning ot the ending.