Rearrange EXISTING textboxes FIRST and then new textboxes should come bottom of EXISTING

[NametobeRenamed]

Hello,

When I export data into text boxes (from one sheet to another - DataFill to LeadershipKanbanBoard) first time everything is getting exported as expected. The real problem starts with the second export, let me tell you why, please check below for details

Expected result, difficulties and reasons
1. First export all textboxes are coming as expected. These are going into sheet 2 (LeadershipKanbanBoard); coming into 'To-Do' section and this is perfectly as per my expectation.
2. Second step after export is Business Users/Users manually moves the text boxes to different sections (in sheet2-LeadershipKanbanBoard’) due to which there will be some gaps formed. Please check sheet (LeadershipKanbanBoard) for details (attachment).
3. Difficulty or what is that I want - I want Textboxes to get rearranged in sheet2 (LeadershipKanbanBoard) especially which are in section 'To-Do', if possible even in other sections (In Progress, Impediment and Done).
4. Step 2 of what I want - If I run AddFeatureTextBoxes Macro (or click on Export Data button which is in DataFill sheet). I want data which is in this sheet1 (DataFill) should be moved to Sheet 2 (LeadershipKanbanBoard) but these Textboxes should come BOTTOM in the To-Do section.
5. I request to please check attachment (Expected Result Sheet - I also kept all my requirements in this sheet).

I request someone to please check and help me!! Thanks in advance!!

[Andy Pope]

This uses the zorder to arrange the shapes within a set of columns.

Please Login or Register  to view this content.

[NametobeRenamed]

First of all, thank you very much Andy!!

Your script is working exactly as I need but the problem is with the second part. When I run my 'AddTextboxes' Macro then the new textboxes are getting added on top of the existing whereas I need these to be added after the last textbox available in To-Do Column. Can you please check my attached screenshot (TextBoxes Getting Overlaid On Top of Existing.PNG) for the defect. And the ExpectedResult sheet for more details/desired expectation.

[Winon]

Hello NametobeRenamed,

Kudos to Andy Pope with his clever approach! You must please add to his Reputation.

The easiest way to solve your new issue would be playing around with the Code you now have.

No need to change the Macro's assigned to the Buttons.

Please try the attached sample Workbook.

Regards.

[NametobeRenamed]

Thank you very much Winon!!

I got what you did and trying to say. Yes, I should you have played with the code more. I was thinking much than required, more then thinking I should have applied my brains in playing the code (step 1 after step 2 0 by this I should have figured it out) ... I will follow your suggestion for sure

[Winon]

You are welcome NametobeRenamed,

Glad we could help

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

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Regards.

[NametobeRenamed]

Hello Winon - I followed your above mesg. and exactly did as you suggested.

But after testing few things in the spreadsheet, I found a major/critical bug and I couldn't able to resolve myself, so that the reason coming for your help again (in fact both of you - Winon and Andy Pope). I'm making this thread form resolved to Unresolved.

Bug - I see
1. If there are more than 3 boxes in In Progress (Column D-F) or Impediment (Column G-I) or Done (Col J-K) sections and if I run ArrangeTextBoxes Macro then - the text boxes in the section are moving into To-Do section and getting OVERLAID from the 4th Textbox (or 2nd Row of textboxes). And this is happening for text boxes in all three sections if more than three boxes.
********** Say if I have 5 boxes in In Progress and 6 boxes in Impediment section then ..... 2 from In Progress section first getting overlaid on 4th and 5th text boxes in To-Do section and 4th, 5th and 6th boxes from Impediment section are getting overlaid on 6th, 7th and 8th text boxes in To-Do.

Expectation - Textboxes placed within each section (To-Do, In Progress , Impediment and Done) should arrange within. Boxes shouldn't move from one section to another (or into To-Do), then my whole purpose/aim of creating this getting into vain. Can you please please please adjust the code accordingly. I hope you understand this bug clearly and for more details, can you please look into attachment screenshots and workbook. Thanks a ton in advance!!

[Andy Pope]

The initial Left value, when moving down a layer, needs to include the offset of the columns it is processing.

Please Login or Register  to view this content.

[NametobeRenamed]

Thank you very very much Andy!!! I really appreciate all your help!!
You and Winon did an awesome work and you both are my super stars!!

Closing this thread (making it to resolved)