I am looking for a VBA / macro expert to build a tool that can automatically draw org charts in Excel.
The data is in spreadsheet form with a number of columns showing where each team sits and how each team is related. For example, column 3 says the name of the team is called BIG; column 2 says that the next team up the ladder (on the next level) is called BIGGER, and column 1 says that the next team above that is called BIGGEST. The spreadsheet has many of these rows. Obviously, each team can have a number of teams below it. For example, team BIGGER could also have a team called SMALL sitting below it.
Ideally the tool will draw the org chart and put in each box in the chart the name of the team and the number of staff (shown in column 4 of the spreadsheet).
Only VBA / macro can be used to build the tool to work in Excel 2003.
I need the tool by next week.
19 freelancers are bidding on average $72 for this job
Hi, I have more 10 years experience in MS Excel and MS Office automation, so I'm realy GURU in this. I can help you with this project. Best Regards, Alex