- Joined
- Apr 13, 2012
- Messages
- 8
- Reaction score
- 0
[FONT="]Hi there-
The data I'm working with is exported from an online system and comes in the following format:
[/FONT]
Account AAAA Desc 1111
XXXXXX1 XXXX1 XX1 XXX1
XXXXXX1 XXXX1 XX1 XXX1
Account BBBB Desc 2222
XXXXXX1 XXXX1 XX1 XXX1
XXXXXX1 XXXX1 XX1 XXX1
XXXXXX1 XXXX1 XX1 XXX1
What I need it to look like is this:
AAAA 1111 XXXXXX1 XXXX1 XX1 XXX1
AAAA 1111 XXXXXX1 XXXX1 XX1 XXX1
BBBB 2222 XXXXXX1 XXXX1 XX1 XXX1
BBBB 2222 XXXXXX1 XXXX1 XX1 XXX1
BBBB 2222 XXXXXX1 XXXX1 XX1 XXX1
[FONT="]
[FONT="]I'm hoping to use a vba code to do this but I don't have too much experience with writing them. Also the number of rows between the accounts won't necessarily be the same every time.
[/FONT][FONT="]
Please help if you can!!!!!
-Ashley[/FONT][/FONT]
The data I'm working with is exported from an online system and comes in the following format:
[/FONT]
Account AAAA Desc 1111
XXXXXX1 XXXX1 XX1 XXX1
XXXXXX1 XXXX1 XX1 XXX1
Account BBBB Desc 2222
XXXXXX1 XXXX1 XX1 XXX1
XXXXXX1 XXXX1 XX1 XXX1
XXXXXX1 XXXX1 XX1 XXX1
What I need it to look like is this:
AAAA 1111 XXXXXX1 XXXX1 XX1 XXX1
AAAA 1111 XXXXXX1 XXXX1 XX1 XXX1
BBBB 2222 XXXXXX1 XXXX1 XX1 XXX1
BBBB 2222 XXXXXX1 XXXX1 XX1 XXX1
BBBB 2222 XXXXXX1 XXXX1 XX1 XXX1
[FONT="]
[FONT="]I'm hoping to use a vba code to do this but I don't have too much experience with writing them. Also the number of rows between the accounts won't necessarily be the same every time.
[/FONT][FONT="]
Please help if you can!!!!!
-Ashley[/FONT][/FONT]