Hi Guys
I'm looking a Macro to help with a repetitive job I have every month? Below is an example of a spreadsheet I run each month and currently I have to go down the spreadsheet manually and insert two lines between each unique ident, then a single blank line between each date within each ident...I then have to put page breaks between each Ident group....
So this is how it looks when I start:
Ident SurvAddress Date SystRef
1 *************** 01/08/20 *********
1 *************** 01/08/20 *********
1 *************** 02/08/20 *********
1 *************** 02/08/20 *********
2 *************** 01/08/20 *********
2 *************** 01/08/20 *********
2 *************** 02/08/20 *********
2 *************** 02/08/20 *********
3 *************** 01/08/20 *********
3 *************** 01/08/20 *********
3 *************** 02/08/20 *********
3 *************** 02/08/20 *********
4 *************** 01/08/20 *********
4 *************** 01/08/20 *********
4 *************** 02/08/20 *********
4 *************** 02/08/20 *********
And this is how I need it to look:
Ident SurvAddress Date SystRef
1 *************** 01/08/20 *********
1 *************** 01/08/20 *********
1 *************** 02/08/20 *********
1 *************** 02/08/20 *********
Page Break
2 *************** 01/08/20 *********
2 *************** 01/08/20 *********
2 *************** 02/08/20 *********
2 *************** 02/08/20 *********
Page Break
3 *************** 01/08/20 *********
3 *************** 01/08/20 *********
3 *************** 02/08/20 *********
3 *************** 02/08/20 *********
Page Break
4 *************** 01/08/20 *********
4 *************** 01/08/20 *********
4 *************** 02/08/20 *********
4 *************** 02/08/20 *********
The spreadsheet is thousands of lines long so any help would be appreciated.
Thanks
I'm looking a Macro to help with a repetitive job I have every month? Below is an example of a spreadsheet I run each month and currently I have to go down the spreadsheet manually and insert two lines between each unique ident, then a single blank line between each date within each ident...I then have to put page breaks between each Ident group....
So this is how it looks when I start:
Ident SurvAddress Date SystRef
1 *************** 01/08/20 *********
1 *************** 01/08/20 *********
1 *************** 02/08/20 *********
1 *************** 02/08/20 *********
2 *************** 01/08/20 *********
2 *************** 01/08/20 *********
2 *************** 02/08/20 *********
2 *************** 02/08/20 *********
3 *************** 01/08/20 *********
3 *************** 01/08/20 *********
3 *************** 02/08/20 *********
3 *************** 02/08/20 *********
4 *************** 01/08/20 *********
4 *************** 01/08/20 *********
4 *************** 02/08/20 *********
4 *************** 02/08/20 *********
And this is how I need it to look:
Ident SurvAddress Date SystRef
1 *************** 01/08/20 *********
1 *************** 01/08/20 *********
1 *************** 02/08/20 *********
1 *************** 02/08/20 *********
Page Break
2 *************** 01/08/20 *********
2 *************** 01/08/20 *********
2 *************** 02/08/20 *********
2 *************** 02/08/20 *********
Page Break
3 *************** 01/08/20 *********
3 *************** 01/08/20 *********
3 *************** 02/08/20 *********
3 *************** 02/08/20 *********
Page Break
4 *************** 01/08/20 *********
4 *************** 01/08/20 *********
4 *************** 02/08/20 *********
4 *************** 02/08/20 *********
The spreadsheet is thousands of lines long so any help would be appreciated.
Thanks