Vba smart Art

B

blatta

Board Regular
Joined
Sep 7, 2004
Messages
67
Hello,

Is is possible to have a VBA to generate a smartart hierarchy based on data in a worksheet.

The data in the worksheet is currently structured as follow:

Name Reports to
ENT_BG235
ENT_YG235 ENT_BG235
ENT_BUGP ENT_BG235
ENT_YUGP ENT_BUGP
ENT_H0416 ENT_BUGP
ENT_Y0416 ENT_H0416
ENT_S0319 ENT_H0416
ENT_S0445 ENT_H0416
ENT_S0061 ENT_H0416
ENT_S0355 ENT_H0416
ENT_S0354 ENT_H0416
ENT_H0261 ENT_BUGP
etc...



Thanks in advance.
Alain
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
You must log in or register to reply here.

Similar threads

O
  • Question Question
Change node shape colour based on text within shape
Replies
1
Views
699
Domenic
D
CesarF
  • Question Question
Need Help Generating PDF Paginated Reports from Excel VBA
Replies
2
Views
159
CesarF
CesarF
U
  • Question Question
Copy data from different sheet to another sheet using activecell offset
Replies
3
Views
257
jolivanes
jolivanes
N
  • Question Question
Automating VB-Tax form reports
Replies
1
Views
70
Ndk
N
A
  • Solved
Copy 4 columns from smart table to other smart table
Replies
1
Views
245
JerrExcel
JerrExcel

Forum statistics

Threads
1,224,586
Messages
6,179,730
Members
452,939
Latest member
WCrawford

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top