Macro for AutoFill

[kabushnell]

I have a macro that I would like to copy the data in column B down to the last record in column C. The number of rows changes daily. I can get it to copy to a specific number of rows but I am not quite sure how to get it to look at the number of rows in C and only copy B to that number of rows.

 

[PHV]

Take a look in the FAQ area for finding the last row.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244