Macro to align formating

[taxx411]

Can anyone help me record a macro or create a macro that will copy the row underneath and paste it above? I have an export of 3000+ rows and I would prefer to automate this task. When I record a macro it only modifies that same range when the recording took place. How do you tell a macro to do the same for other rows and columns?

[AliGW]

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you have not posted here often, I have done it for you this time.)

[alansidman]

I have looked at your file and have no idea what you want to happen. Please explain in detail using the file you have provided as an example. Show us some sample mocked up results.

A sample file need only have 8-15 records, not 7000.

[taxx411]

Alan - Good point. I apologize for sending such a large file.

There is data in the file that looks complete and data that is scattered.

I want a macro that will automatically copy the address from underneath and bring it up as I've done with other rows. And also delete that row where the data was copied from.

I can show you over zoom if possible

[alansidman]

How will I know which are complete and which are not. Provide examples of both so we know what to do. You know your workbook. We don't. You need to be explicit in your explanations to us. Do not assume we understand your workbook just because you uploaded a sample. Explain it with examples and not generalities.

[taxx411]

Please read the instructions in the new sample file.

A new file called VBA

Yellow is the final product

Red = raw data

[alansidman]

Please Login or Register  to view this content.

[taxx411]

Thank you. I'm just getting started with VBA.

Any idea where I need to place this code?

[alansidman]

How to install your new code

• Copy the Excel VBA code
• Select the workbook in which you want to store the Excel VBA code
• Press Alt+F11 to open the Visual Basic Editor
• Choose Insert > Module
• Edit > Paste the macro into the module that appeared
• Close the VBEditor
• Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

• Press Alt-F8 to open the macro list
• Select a macro in the list
• Click the Run button

[taxx411]

Thank you it worked but I need to clean up my spreadsheet. You're a life-saver.!

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.