Re Format Columns and Rows

[cartica]

Hi,

I currently receive data in the format A2:D4 although many more rows. I would like to be able to automate the current format to format I manually arranged in F2:G8. It would be too cumbersome to do it manually for all the data. Not sure if there is a formula, or some type of Macro that can do this? Any help would be greatly appreciated.

How can I attach an Excel sheet?

[walruseggman]

Please Login or Register  to view this content.

[cartica]

Thank you, that works. Can you explain your code?

[walruseggman]

Please Login or Register  to view this content.

[cartica]

Thank you. How would I change the Macro If I wanted to Copy format that data to a different tab called "Formatted Tab". Not sure if below would be right. Also,let's say I want instead of data to fill in column F and G, to be A and B?

Please Login or Register  to view this content.

[walruseggman]

Change the name of your source data sheet on the first line to match your actual sheet name, if needed. I have it creating a new formatted tab for you every time you run the code.

Please Login or Register  to view this content.

[cartica]

Thanks. Sorry for all the questions. Where in your formula does it state to start the data in the newly created field in column A row 3? Also, how can I have a header in a1, and b2 if you create a new sheet?

[walruseggman]

Where in your formula does it state to start the data in the newly created field in column A row 3

This code is in format Cells(Row Number, Column Number):

Please Login or Register  to view this content.

So I start j at row 3 and increment it after every copy, and the 1 is column A.

Also, how can I have a header in a1, and b2 if you create a new sheet?

Like so:

Please Login or Register  to view this content.