Macro to fill down based on number contents of adjacent cell or other sheet : I've seen a few other posts similar to this but I can seem to get mine to work. Right now I have data in Column A, from A5 to A50 but the end point is subject to change. I am looking for a macro to select B5 to Y5 and fill down to the end of column A (in this case to row 50, but this will change every time). 

The amount of rows depends on another sheet. As an alternative to my question above, if there is a way to go to the other sheet, and count the rows in column A, from A4 down and then fill down in my other sheet that amount that would be just as good.

**Summary**
- I have one sheet with the data, starting at A4 and going down for an amount that will be changing.
 - I would like to be able to fill down on another sheet the number of rows there are in the first sheet.

Hopefully this makes sense, and thanks for the help.