Drag down cells until last text cell

[lorena.tgarza]

Hi,

I want to create a macro that will drag down a range of cells with formulas to the last cell with text on it. How can I do that.

I attach an example of what I want to do.

I want to select D3:G3 and drag it down to D8:G8. I want the rows to be dynamic since it will not always be row 8 until I will need to drag down.

Regards!

[mike7952]

Maybe this

Please Login or Register  to view this content.

[lorena.tgarza]

HI Mike!!

Thanks a lot. But how can i make the range variable since it will no always be row 3??, the columns will always be the same but the rows will vary!

Regards!!

[mike7952]

Not sure Im following you. It wont matter how many rows there are it will copy down.

[lorena.tgarza]

Hi Mike

What I mean is that my database will be updated daily from columns A:C so right now my last cell with value in column D:G is 3 but the day after tomorrow after it is updated my last cell with value in column D:G might be 10. How can I tell the macro to look for the last cell with value in columns D:G and drag those cells down until they match the cells with value of columns A:C??

[mike7952]

The other code would work to. But is this what you want?

Please Login or Register  to view this content.

[lorena.tgarza]

Thanks a lot Mike. Exactly what I needed. Worked out perfectly!

Regards!!!