Aperras7
New Member
- Joined
- May 22, 2014
- Messages
- 36
Hello all,
I know that this question has been asked a thousand time before, but I can't find the perfect one for me. I'm looking for a VBA that takes all my rows and separate them into multiple sheets in the same document. Here's exactly what i'm looking for:
- something that keeps my formating and cell width.
- something that would give the name of the first ell in each row to the new sheets (every row begins by a unique code)
- something that will copy the headers for every new sheets
As I said, every row begins by a different code. The table is called Leases and here's the data reference including headers : A1:AY201
I'm using Excel 2007 by the way.
thank you all,
Example :
<tbody>
</tbody>
I know that this question has been asked a thousand time before, but I can't find the perfect one for me. I'm looking for a VBA that takes all my rows and separate them into multiple sheets in the same document. Here's exactly what i'm looking for:
- something that keeps my formating and cell width.
- something that would give the name of the first ell in each row to the new sheets (every row begins by a unique code)
- something that will copy the headers for every new sheets
As I said, every row begins by a different code. The table is called Leases and here's the data reference including headers : A1:AY201
I'm using Excel 2007 by the way.
thank you all,
Example :
Store No. | Location | Fran/Corp/Sub | ... |
3 | P*** - Street Level | Corp | ... |
3.1 | P*** - Mezzanine Level | Corp | ... |
<tbody>
</tbody>