Do-Loop to Add Text to Labels

[mcmahobt]

Hello forum,

A little out of my league here with Labels that aren't being used within charts. The attached workbook has my example that I'm hoping will make more sense.

I am trying to create a scheduling tool that will adjust label sizes according to Start and Finish dates that are given in columns C and D. A code a colleague of mine has produced seems to do the trick, but with static ranges. I'd like for a loop to cycle through column A, and bin the necessary fruits according to column G, and have the label code (or some variant thereof) execute and incorporate a new label for each piece of fruit, signaling it's duration or shelf life.

Label code given below:

Please Login or Register  to view this content.

Hopefully this explanation wasn't clear as mud!?

[WouterM]

Hi,

I have tried something.
First I have added some names to ranges on the sheet.

Hoop this will help you

WouterM

[mcmahobt]

This is great, thank you! I think I shot myself in the foot with data setup, because the two data sets are actually on separate worksheets. Attached is more like how it is setup. I'm working to replace the worksheet references now, but you may be quicker.

Thanks again for your help though!

[WouterM]

Hi,

I have changed my version into a workkbook with two sheets.
On de example sheet I have added a button to start the proces.
Which now first removes the existing shapes before adding the wanted ones.

Hoop this helps,

WouterM

[mcmahobt]

Thanks for the quick reply, this is perfect for what I need!