Excel Macro assistance please.

Closed
vanilla_thunderrr - Jan 12, 2011 at 08:28 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 19, 2011 at 09:21 AM
Hello,

I am trying to write a simple Macro which would look at a corporate organizational chart in Excel. The Macro would list the company name and the parent of that company in two columns. I have included an example of the data and the desired output. The actual data will probably consist of a thousand rows or so and up to 20 columns. Each entity is in a different column and row.

AAA
.......BBB
.............CCC
.............DDD
...................EEE
..............FFF

The desired output would be the following:

AAA.....AAA
BBB.....AAA
CCC.....BBB
DDD.....BBB
EEE.....DDD
FFF......BBB

Thank you.

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jan 19, 2011 at 09:21 AM
do you have a sample workbook that you could paste as some share site like
https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back the link here
0