Create Macro To Copy Moving Range of Rows

I am a real novice as it relates to macros and could use some assistance. I have a spreadsheet that pulls info from our Oracle database. I have data in rows A-Z. Columns A-F have descriptions (e.g. property, acct#). Columns G-T contain the actual values. Once the data is retrieved I then have a macro to delete the zero rows. What I then need is a macro to do the following:

Once my zero rows are deleted I need to have the block of data copied 3 rows below the last row of the data that was retrieved. My header line will always start at A10. The trick here is that the range of rows will change depending on the data that is retrieved and deleted.

I then need to have a separate macro created to take the newly copied block of data and then have that info copied to a new workbook within the same spreadsheet.

Any help here would be greatly appreciated.

Thanks!

Hi

How about

Please Login or Register  to view this content.

rylo

Thanks Rylo. I was able to take pieces of this macro and just use the piece for repeating the data below the original range.

You have saved me hours of work! Thanks again!

One last thing. Is it possible for you to add the code that lets you paste the data as values? Currently I have formulas in the data I am copying and I want to make the duplicate data values only.

Any help would be appreciated.

Thanks!

Hi

Here goes

Please Login or Register  to view this content.

rylo

Rylo,

Thanks again . I can't thank you enough as I would have spent days trying to think of another solution that would not be even close to this. This is exactly what I needed to complete my project.

Just picked myself up one of those beginner Excel VBA Programming books to start getting a feel for doing some of these things on my own.

B