Filling down?

G

GeoffreyBarnard

Joined
Jul 25, 2007
Messages
26
Reaction score
0
Can someone help me? I have in column "B" the first 6 cells have the formula "=RAND()". In column "C" the first 6 cells are merged and equal "Team Name", then the next six and so on. In column "D" the first 6 cells are merged and equal "Team Number",then the next six and so on. In column "E" the first 6 cells are merged and equal "Team players",then the next six and so on. I want to fill these cells down after the last used. I hope this makes sense. GeoffreyBarnard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Strip out certain rows that have merged cells 2
Modify working code to expand the output. 5
Merging cells 0
SUMPRODUCT Error 3
Excel 2013 Merge Data 2
wildly varying execution speeds - is it the code? 3
any ideas why execution speed varies? 4

Top