Convert Coloums in Sheets

[liarliar]

Dear All,

I have a worksheet with many coloums with dates . I would like to create a macro whereby it will extract coloumn Ato G in each sheet which will be fixed with the each Date coloum as one sheet and rename the sheet as per the date.

An example is enclosed for reference

[liarliar]

Guys please help as its very important as I need to come up within this weekend. Thanks a ton in advance

[mbarmecha]

Hi

you can do it by copying the column data in sheets

[shg]

I would like to create a macro whereby it will extract column A to G in each sheet which will be fixed with the each Date column as one sheet and rename the sheet as per the date.

I can't parse that at all. Maybe if you posted the desired result ...

[Hurundee]

why don't you use a pivot table instead of designing a macro? It will give you the data the way you want and when you click on a particular date it will show you all the data pertaining to that date on a new worksheet.

[liarliar]

Hi,

Well the desired result that we want is that say the first five coloums will be fixed for all sheets and then for each coloums of the date there will be a seperate sheet with the date as sheet name and the first five coloums will be there for all.

I am enclosing the desired result.

[SOS]

Hi liarliar,

Try the following code

Please Login or Register  to view this content.

[liarliar]

Thanks a ton worked like a charm