VBA for formatting/layout of printed pages

[SecFire]

Hi,
I have a large spreadsheet of data that contains names, addresses, and various other info. I’ve created vba that allows me to sort it all by geographic location which greatly reduces the amount of data I have to work with at once. I do need to print the results of various queries/filters, and I am wondering if it is easily possible to use cvs to format the layout of each record on the pages very specifically.

Right now, all data is in rows and columns, but since people will be handling the printed pages during door to door visits, I’d like to format it so that the town name for all records is printed once at the top of the page, with house numbers, name, address formatted almost mailing label style in an organized way that would make it easier to follow while going door to door.

Before I put any considerable time into trying, I’d like to know if this is possible. Can anyone advise?

[Greg M]

Hi there,

I'd like to know if this is possible

Very likely, but not without a lot of information regarding data layout etc.


Also,

I am wondering if it is easily possible to use cvs to format the layout of each record

The only reference I've found to "cvs" is "Cyclic Vomiting Syndrome" - am I missing something?


Regards,

Greg M