How to automate text addition after a new entry linked to another table ?

Hi guys,

I know the title sounds weird but I couldn't find one more precise.

If you take a look at my file, you'll understand what I'm trying to do.

I want to link Partners name in my Schedule sheet to another sheet ( Partners names). When we add one in the Partners name table, it automatically populates the other sheet with the new name BUT spaced by 5 rows. So that I can have my Steps below, in the next column.
Work template.xlsx

I want this process to be an automation based on a new entry in the partner names sheet.


Million thanks in advance, I've tried everything that I had in mind.

Put this in E7 of Sheet2:

=IF(MOD(ROWS($1:1)-1,6)=0,INDEX('Prtners names'!C:C,INT((ROWS($1:1)-1)/6)+7),"")

then copy down as far as required.

Hope this helps.

Pete

It does !

That is super nice, thanks a lot !

Just so that I know, if I want to add new steps between each partner names, what do I have to change in the Rows formula ?

Once again, thank you !

Guillaume

At the moment you have a block of 6 rows, one name and five steps, so that is why there are two 6's in the formula - if you wanted to have a block of 8 rows, then change the formula to this:

=IF(MOD(ROWS($1:1)-1,8)=0,INDEX('Prtners names'!C:C,INT((ROWS($1:1)-1)/8)+7),"")

(changes shown in red), and copy down.

Incidentally, this would be a better formula to use in F7:

=IF(MOD(ROWS($1:1)-1,6)=0,"",INDEX(A:A,MOD(ROWS($1:1)-1,6)))

which can be copied down as far as you need. Again, you could change the two 6's if you had a larger (or smaller) block.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete

Thank you for the tips Pete.