Hi all,
I have a loooong VERTICAL list of names and addresses of companies. All of the information is in one column, let's say, column A. Each company is separated by a couple of blank rows.
I can do a Transpose on Company #1 , starting at let's say A2. Maybe a total of 5 rows. It results in the entire information spread out along B2.
If I record all my actions in a macro, and then go to Company #2 , the macro will work except for one very important detail, it results in the information spread out along B2 as well. It just overwrites what was there before.
Obviously, this is useless. How do I get around this?
Thank you.
Jesse
I have a loooong VERTICAL list of names and addresses of companies. All of the information is in one column, let's say, column A. Each company is separated by a couple of blank rows.
I can do a Transpose on Company #1 , starting at let's say A2. Maybe a total of 5 rows. It results in the entire information spread out along B2.
If I record all my actions in a macro, and then go to Company #2 , the macro will work except for one very important detail, it results in the information spread out along B2 as well. It just overwrites what was there before.
Obviously, this is useless. How do I get around this?
Thank you.
Jesse
Last edited: