Hello All,
I have on Big excel file that was created by exporting multiple crystal reports. Now from this excel file I would like to copy a range of cells to different worksheets ( have about 15 different worksheets). I can use something like
Range("A36:M71").Copy Worksheets("1").Range("A1")
But the problem is range is not fixed all the time in the exported excel file. Can some one please help my with VBA code? The identifier, that I can use is the company name, in the exported excel file i have each report start with my company name.
Any help will be appreciated.
Thank you.
I have on Big excel file that was created by exporting multiple crystal reports. Now from this excel file I would like to copy a range of cells to different worksheets ( have about 15 different worksheets). I can use something like
Range("A36:M71").Copy Worksheets("1").Range("A1")
But the problem is range is not fixed all the time in the exported excel file. Can some one please help my with VBA code? The identifier, that I can use is the company name, in the exported excel file i have each report start with my company name.
Any help will be appreciated.
Thank you.