В работе

Build hierarchy type presentation of data in Excel

I have a data about company,country,state,city data in excel sheet, ([url removed, login to view])

How to convert tree like hierarchy data like, ([url removed, login to view])

ee ref link: Build a tree like representation of data in Excel?

In my case, I have four column data, Thats why above link's answer code didnt work for me.

So, How to do this using only VBA?

I want excel vba script, it convert tree like hierachy my data.

Anyone interested, Contact me.

Thanks,

Venkat

Can we do output in this text format from Excel?. Its .txt file

ABC-1
*India
**Tamilnadu
***Chennai
**Kerala
***Palakadu
**Maharashtra
***Mumbai
**Goa
***Goa
*UK
**Wales
***Bangor
***Cardiff
**South East England
***Bristol
*US
**Alabama
***Alabaster
***Adamsville
BCD-2
*India
**Maharashtra
***Mumbai
**Tamilnadu
***Salem
**Kerala
***Trivandrum
**Goa
***Goa
*UK
**North East England
***Carlisle
**Northern Ireland
***Belfast
**South East England
***Bath
*US
**New York
***New York City
**California
***Los angeles

Kindly contact me, if interested.

Навыки: Excel, Visual Basic

Показать больше: country state city data excel, excel presentation data chart, free country state city excel, world region country state city list excel, region country state city list excel, excel list country state city, country state city database excel, excel country state city list, hierarchy database country state city, australia country state city hierarchy, type pdf data excel, country state city excel data, data analysis excel presentation report, country state city dropdown data, data entry job type data pdf excel, list country state city data, country state city list excel, country state city data, send data excel program, extract data excel drop form html, read data excel file, convert pdf data excel sheet, export data excel database java, perl script retrieve data excel, export jsp data excel javascript

О работодателе:
( 2 отзыв(-а, -ов) ) Chinnasalem, India

ID проекта: #12262901

Поручено:

InnocentSathish

Hi, Thanks for showing interest to read my bid. I’m may be new user to freelance, but I have 6+ year exp in excel & VBA, Area of experience: VBA for MS office applications, Excel, oracle, sql, BI-applications. W Больше

$10 USD за 1 день
(0 отзывов(-а))
0.0

20 фрилансеров(-а) подали заявки на эту работу; средняя заявка - $21

nagybatonyi

Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macr Больше

$20 USD за 0 дней(-я)
(58 отзывов(-а))
5.7
MoohHHooM

Hi, i can help you with this project, please let me know more about it :) Больше

$30 USD за 0 дней(-я)
(19 отзывов(-а))
4.9
vsprybhanu

Hi, Experienced Excel VBA and VB.Net Programmer. I have read your instructions carefully and saw your attachments. Yes it is possible to design hierarchy structure as like [url removed, login to view] from source data of Source Больше

$30 USD за 1 день
(43 отзывов(-а))
4.8
mallikasomu87

Hi, I looked into your output. I can create this kind of tree like output using pivot tables itself. Looking forward to hear from you!

$25 USD за 1 день
(9 отзывов(-а))
3.9
$15 USD за 0 дней(-я)
(10 отзывов(-а))
3.6
royalcalif

I have done your requirement. Please see the screen shot [url removed, login to view] See the below video as sample a Hierarchy [url removed, login to view] Hi Больше

$25 USD за 1 день
(14 отзывов(-а))
3.7
MykolaDudych

Hello, I am interested in your offer and I am ready to cooperate. I have experience in writing macros Excel.

$10 USD за 1 день
(4 отзывов(-а))
2.7
$10 USD за 0 дней(-я)
(4 отзывов(-а))
2.1
vivirain

Hi, I can help get it done as demanded within 1 day. Feel free to contact me if any. Best Regards, VL

$30 USD за 1 день
(2 отзывов(-а))
1.9
ByteInterfaceInc

Looks easy and doable. I have developed similar kind of macros in past. I can do this in 3 days. Looking for my first opportunity here.

$15 USD за 1 день
(0 отзывов(-а))
0.0
$20 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
narjiskhatoon47

Contact me for quality work and reasonable fee. I am a professional in this. I assure you that you will get 100% work done as you want and with in given time. Contact me as soon as possible if you want to get your work Больше

$22 USD за 1 день
(0 отзывов(-а))
0.0
mahmoud249

Hi . l have great experiences dealing with Excel and VBA , you can do this easy by VBA l looking forward to working with you . thanks .

$10 USD за 1 день
(0 отзывов(-а))
0.0
$25 USD за 1 день
(0 отзывов(-а))
0.0
$25 USD за 1 день
(0 отзывов(-а))
0.0
RankXaroth

I am experienced VBA programmer. Did many VBA transformation macros - updating data tables from one excel sheet to another. Did procedures which create new sheet with data. I am ready to discuss the details with you.

$25 USD за 3 дней(-я)
(0 отзывов(-а))
0.0
SantanuDutta

You can create n numbers of tree and sub tree by my developed software. but you have to brief description of your requirement, better to draw a scratch.

$28 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
project4u4me

Hello. I have experience in performing such tasks. I have 20 years of experience in marketing analysis. I'm fluent in MS Excel and Access, VBA and SQL, PHP and MySQL. Timely and accurately perform this type of w Больше

$25 USD за 1 день
(1 отзыв)
0.1
stocktimemachine

I've had similar work You can see it here. [url removed, login to view] Thank you.

$15 USD за 1 день
(0 отзывов(-а))
0.0