Selecting Next Column After a Specific Row

[NewExcelUser]

Hello,

Ok, this is a tough one (for me)

I have a macro which pastes data from one worksheet to another. I would like to specify that the information that is pasted to continue to be pasted on a specified column once the information has reached row 52.

Is there a procedure for this?

TIA

[rylo]

HI

How does your existing procedure paste the data? Does it copy / paste a block? or does it have some sort of incrementing counter that is used to determine a row???


rylo

[NewExcelUser]

Hello,

Thanks for the reply. It copies and pastes blocks at a time from different parts of the worksheet onto one worksheet. I guess I could use a counter. How would this be implemented?

Many Thanks.

[rylo]

Hi

Is the block to be split across the different columns, or do you want to move to another column once the next available output row is > 52?

rylo

[NewExcelUser]

Hi,

Is the block to be split across the different columns, or do you want to move to another column once the next available output row is > 52?

I want it to move to another column once the next available output row is > 52.

Thank you for your time! I really appreciate it.

[rylo]

HI

This is pretty generic, but I hope will give you the idea.

Please Login or Register  to view this content.

If this is in your copying / pasting routine, it will test the next available posting row in your current column. If it is >52, then it will reset the row and column variables you can use to set the output cell reference.


HTH

rylo

[NewExcelUser]

Thanks Rylo,

I have been so busy with another part of this project that I haven't gotten time to try it. Once I do I will, but I wanted to thank you for your time.