Sorted Custom Views

[Weston]

Hi. I need to create a process for a co-worker to cut and paste a list of employees into a spreadsheet, sort it, print it, then sort it differently, print that version with a different title, sort it again, etc. This needs to be kept simple and as automatic as possible.

In total, there are four versions of the printed report. Each is identical but each is sorted on a different column and has a different header when printed. I've turned on AutoFilter to make sorting easier. I've created four Custom Views with different print headers in each. But the views do not retain their sort order. I was hoping to use an Excel Report to bring together the four sorted Views into a single print process, but that ain't happenin'.

For now: Select a View, sort for that View, print. Repeat for each View.

Sounds simple, but there's room for error and this is being done frequently enough that it merits more automation.

If this were Lotus 1-2-3, I'd write a simple macro. But I know almost nothing about Macro Recorder or VB.

Any ideas?

Thanks.

[Bryan Hessey]

Hi. I need to create a process for a co-worker to cut and paste a list of employees into a spreadsheet, sort it, print it, then sort it differently, print that version with a different title, sort it again, etc. This needs to be kept simple and as automatic as possible.

In total, there are four versions of the printed report. Each is identical but each is sorted on a different column and has a different header when printed. I've turned on AutoFilter to make sorting easier. I've created four Custom Views with different print headers in each. But the views do not retain their sort order. I was hoping to use an Excel Report to bring together the four sorted Views into a single print process, but that ain't happenin'.

For now: Select a View, sort for that View, print. Repeat for each View.

Sounds simple, but there's room for error and this is being done frequently enough that it merits more automation.

If this were Lotus 1-2-3, I'd write a simple macro. But I know almost nothing about Macro Recorder or VB.

Any ideas?

Thanks.

You should be able to set this up with Record a Macro, just check the macro for any specific Row numbers, and replace with the iLastRow, usually derived from
iLastRow = ActiveSheet.Range("A65536").End(xlUp).Row
etc (for column A)

hth
---