smoskowitz
New Member
- Joined
- Jul 21, 2010
- Messages
- 10
Hello --
I am a VBA newbie trying to make my job easier.
I currently have a file in the following format
2
3
4
5
6
7
How would I writer code to create an excel sheet that looks more like this:
AAA 1
AAA 2
AAA 3
.
.
.
GGG 7
All I want to do is convert the grid format to more of a flat file format and don't know how to do this. I would like the code to be dynamic enough to figure out how many rows and columns I have.
Thanks,
Seth
I am a VBA newbie trying to make my job easier.
I currently have a file in the following format
AAA BBB CCC DDD EEE FFF GGG
12
3
4
5
6
7
How would I writer code to create an excel sheet that looks more like this:
AAA 1
AAA 2
AAA 3
.
.
.
GGG 7
All I want to do is convert the grid format to more of a flat file format and don't know how to do this. I would like the code to be dynamic enough to figure out how many rows and columns I have.
Thanks,
Seth
Last edited: