macros - help needed

[JT1]

Hi, I am trying to record a simple macro ... a simple repetitive task (moving and removing cells) which I would like to be applied over a whole spreadsheet. So I record several repetitive steps of the macro and then I try to run the macro in the actual spreadsheet. The result is that the macro repeats only the couple of steps that I have recorded.

How do I apply the macro over the whole spreadsheet??? Can you help please?

Thanks JT

 

[clut]

If you record a macro, and then run that macro Excel will perform exactly the same operations as when you recorded.

If you want to macro to run more times, for to keep running itself over multiple sheets or cells then you need to go in and edit the macro.

You'll need to be more specific about what you want to acheive for anyone to be able to help.

 

[JT1]

Hi and thanks.

I have addresses in column A ... all addresses are spread over 7 rows ... name A1, street A2, etc. (all data in column A)

Now I need to bring the spreadsheet to a format, where all addresses will be in 7 rows - names row 1, streets row 2, etc.; address one in column A, address two in column B etc.

Do you know what I mean?