Macro that moves rows to another sheet.

**Ricksterr94** · 08-02-2014, 05:25 PM

Dear community,

In an Excel file that I created I created a formula that copies data from two lists to one big list. Now the formula is making my workbook run a little slower than I like. Therefore I would like to substitute the formula with a Macro. The problem is I do not have a lot of knowledge on how to create a macro.

This is my workbook: Test.xlsb

Now if you look at sheet Insurances 2014 and 2015, you see a list generated at each bottom of the sheet. Therefore, there are two lists. In sheet "allpayments" I have those two sheets combined so I have an overview of all my payments forever. Now I would like to create the same thing as you can see in Allpayments but just with a macro, which I ultimately can activate by pressing on a button.

Can anyone help me?

**xladept** · 08-02-2014, 07:01 PM

Hi Ricksterr,

Try this:

Please Login or Register  to view this content.

Macro that moves rows to another sheet.

LinkBack

Thread Tools

Rate This Thread

Display

Macro that moves rows to another sheet.

Re: Macro that moves rows to another sheet.

Thread Information

Users Browsing this Thread

Similar Threads

Plz HELP:Have Macro that moves rows to other sheet but need it to delete later row

vba macro that moves rows of information conditionally

[SOLVED] Need help with Macro that moves row to another sheet

[SOLVED] Check box hiding rows: View moves to where the rows used to be

Problems creating a time macro that moves data from one sheet to another.

Bookmarks

Bookmarks

Posting Permissions