Macro to Copy and Paste a Dynamic Range to a Cumulative List Where There Are No Blank Rows

I would like to have a cumulative list of data (with no blanks) that is created from a macro that copies and pastes-vales a range of data ("B1:B26") to the next blank row in the cumulative list on a seperate sheet titled "Heli Data". The challenge is that I need a macro that pastes-values to a dynamic row so that there are no blank rows in the cumulative data list in the "Heli Data" sheet.

Another challenge is that the copy range must also be dynamic; sometimes there will be one row of data that needs to be copied and pasted ("B1:B25"), but other times there will be up to 8 rows of data that need to be copied and pasted ("B1:I26"). There could be anywhere from 1-8 rows of 25 cells/row that need to be copied and pasted at a given time, with no indicator until the user enters them into the user sheet (named "Allocation" which is the location of the cells that need copied).

Please assume that the cells to be copied are in (rows 2:9) and there will 26 cells in each row (columns A:Z), so A2:Z9. I appreciate any help or guidance.


Jordan

Hi Jordan. I think that you may be confusing columns with rows in your description. If you could post a copy of your file with a detailed explanation of what you want to do, it would be easier to help.

Here is a sample file with some comments to clarify my goals and objectives.

Jordan

Hi Jordan. Try:

Please Login or Register  to view this content.

Mumps1,

That worked perfectly. Thank you!

Jordan

My pleasure!

hello i am in need of a copy macro as well.

i am looking for a way of duplicating row enteries six times, for a range over columns.. advice? thank you very much

Hi arcolombo698. Forum rules say that you should not post your question in another person's thread. Could I suggest that you start a new thread with a detailed description of exactly what you want to do. It would be helpful to include a copy of your file.

i sincerely apologize.

here is my problem with a file attached and problem description

http://www.excelforum.com/excel-prog...ata-macro.html

i am new with macros, but if you can write an excel formula instead, that would still suffice.

i thank you in advance.