Copy data from column in one sheet to column in another sheet until blank in F

[votekinky06]

Ok all, need some help here. I have a worksheet, "District", that has names of team members from A2:A (The number of team members will vary, so I would need the macro to stop when the list ends). I need these to be distributed to column A on another sheet, "Input", from A11 down until it hits a row that has a blank cell in column F. I've tried a couple of things, but just can't seem to get it to work. Any help is appreciated!

[Leith Ross]

Hello votekinky06,

It would help to know what things you have already tried. Posting your workbook will give you the quickest turnaround.

[votekinky06]

Hello votekinky06,

It would help to know what things you have already tried. Posting your workbook will give you the quickest turnaround.

Primarily I've tried formulas to no avail, and I've tried recording the macro several times but can't figure out how to loop it and make it stop when it finds the blanks on both sheets. Here's the latest recorded macro I've tried, with some rough adjustments as to what I'm looking for (I know the macro is outrageously incorrect, just VERY new to this game):

Please Login or Register  to view this content.

[Leith Ross]

Hello votekinky06,

It never fails when I am writing code, I get a phone call. Try this macro and let me know the results.

Please Login or Register  to view this content.

[votekinky06]

Hello votekinky06,

It never fails when I am writing code, I get a phone call. Try this macro and let me know the results.

It's giving me a complie error, "Exit Do not within Do...Loop"

[Leith Ross]

Hello votekinky06,


Sorry about that, the correct macro is below. This should work with no problems.

Please Login or Register  to view this content.

[votekinky06]

It's giving me syntax error and highlighting the line below

Please Login or Register  to view this content.

[Leith Ross]

Hello votekinky06,

I need a vacation. I can not believe I have made so many obvious errors today. Change the line to this...

Please Login or Register  to view this content.

[votekinky06]

We're getting closer! It populates the first 19 names and then stops. If it makes it any easier it can just use column A on the "Input" sheet as a determination when to stop and stop when it hits a blank cell on A.

Hello votekinky06,

I need a vacation. I can not believe I have made so many obvious errors today. Change the line to this...

Please Login or Register  to view this content.

[Leith Ross]

Hello votekinky06,

That's good news. I suspect it is stopping because of how I wrote it...

I need these to be distributed to column A on another sheet, "Input", from A11 down until it hits a row that has a blank cell in column F

Did I misunderstand the criteria?

[votekinky06]

No, that's correct. I have 400+ rows on "Input" that have data in column F and it's stopping after 19. Would it help if I uploaded a sample sheet?

Hello votekinky06,

That's good news. I suspect it is stopping because of how I wrote it...

Did I misunderstand the criteria?

[Leith Ross]

Hello votekinky06,

If you can, that would be a great help.

[votekinky06]

Here ya go!
Master Forum Sample Initial State.xlsm

Hello votekinky06,

If you can, that would be a great help.

[Leith Ross]

Hello votekinky06,

Thanks for the workbook. This raises more questions for me. I don't see the relationship between the Team names and the other sheet. Can yo upost a sample of what the output should look like? Just a few lines would be fine.

Also, please don't answer with "Replay With Qoute". It isn't necessary and clutters the response.

[votekinky06]

Master Forum Sample Final State.xlsm

Sorry about the quoting, years of forum habit. I've attached the desired result. I need the team names to be distributed amongst the rows as if I had pasted and then dragged the selection down. It's also worth noting that the team list will start as in this spreadsheet, not the first one uploaded, with the header in A1 and team names beginning in A2. The number of team members and the number of rows on the "Input" sheet will vary. Thanks for all of your help on this!

[votekinky06]

I tried all of the mods I could think of, but just can't figure this one out, do I need to add a line to get it to keep looping?

[votekinky06]

Also, not sure if it helps, but when it stops it fills the rest of the rows down with "#N/A"