Running Macro to copy Rows of Formulas

**cooh23** · 11-11-2007, 05:13 AM

Hello Everyone,

Here's what I am doing:

I have 2 speadsheets, I want to copy rows of Formulas from Spreadsheet 1 and copy them into Spreadsheet 2 but convert them into Values.

Is it possible to create a button on Spreadsheet 1 and assign macro to do exactly what i want? I also want the macro to look for the first empty row in the database so that the information being copied are on the next row and not overwritten.

I hope I am making sense.

Thanks for your help in advance!

**VBA Noob** · 11-11-2007, 05:16 AM

See if link helps

http://www.rondebruin.nl/copy1.htm

VBA Noob

**cooh23** · 11-11-2007, 05:34 AM

Originally Posted by VBA Noob

See if link helps

http://www.rondebruin.nl/copy1.htm

VBA Noob

I am sure the code should work but because I am new to macro's, I might be missing something here.

Here's what I want to do, I want to copy the information from Row number 1 located in the sheet called IWLog and paste the information in an empty row as Values in the sheet called Log.

Thank you.

Here's my code:

Please Login or Register  to view this content.

**VBA Noob** · 11-11-2007, 05:47 AM

You need to read this line again

Important: The macro examples use one function or two functions that you can find in the last section of this page.

As you forgot to add

Please Login or Register  to view this content.

or Instead of a function you can also check one row or column to find the last cell with a value.

Replace this line:

Please Login or Register  to view this content.

With:

Please Login or Register  to view this content.

VBA Noob

**cooh23** · 11-11-2007, 06:12 AM

Thank you!
It worked!

**VBA Noob** · 11-11-2007, 06:16 AM

Your welcome

VBA Noob

**cooh23** · 11-11-2007, 07:22 AM

Another Question:

I have gotten the codes to work, but now I want to copy the info from one worksheet to another worksheet.

The codes below work but it closes the worksheet automatically rather than keeping it open.

Please Login or Register  to view this content.

How do I keep test2 to remain open when running the macro?

Thank you!

**VBA Noob** · 11-11-2007, 07:25 AM

Remove this line

Please Login or Register  to view this content.

VBA Noob

**cooh23** · 11-11-2007, 12:06 PM

Originally Posted by VBA Noob

Remove this line

Please Login or Register  to view this content.

VBA Noob

Removing this code leaves it open but running the macro again does not save the information. It wants to open the file again and discard any changes made.

The reason I want the test2.xls to remain open because it is going to sit on a server and the file is fairly large. So running the macro that opens it and closes it will be time consuming. But leaving it open and just keeps adding rows and saving it later will save me a lot of time.

Thank you again..

I have a feeling that the code needs to be change somewhere here:

Please Login or Register  to view this content.

**VBA Noob** · 11-11-2007, 12:26 PM

This should save changes

Please Login or Register  to view this content.

VBA Noob

**cooh23** · 11-11-2007, 04:06 PM

Originally Posted by VBA Noob

This should save changes

Please Login or Register  to view this content.

VBA Noob

Wow... Thank you very much!

This is going to save me a lot of time.

Running Macro to copy Rows of Formulas

LinkBack

Thread Tools

Rate This Thread

Display

Running Macro to copy Rows of Formulas

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions