Copy Data

[Sandy_X]

Hi all,

i have a nice tool, where i can create Organisational Structures or Work Brakedown Structures.

The help i need now (to extend the features) is, to copy the structure data (which are created by code from the text indented level) from the WBS Maker sheet in columns A (WBS Code) and B (WBS Tasks/ORG structure) into the WBS ORG sheet into columns G (WBS Code) and I (WBS Tasks/ORG structure) and into the WBS PIC sheet into columns G and H (the Pic structure is used for Project Controlling purposes only). Until now, i do this by hand, but it would be nice, if it could be done by one or two VBA routines. Please note, i didn´t copy all the used pictures, because, if you use this feature, all needed pictures have to be in the same file folder as the Tool file.

 

[Hui]

Can you please confirm

1. You want to copy Columns A & B from WBS Maker
to WMS ORG Columns G & I

2. You want to copy Columns A & B from WBS Maker
to WMS PIC Columns G & H

also
What should happens to Text below those two ranges?

 

[Sandy_X]

Hi Hui,

you are right. What i forgot to write is, as i did this by hand, i insert as many rows, as necessary (when i build the WBS structure) so the writings below the text would (should) not be overwritten.