How about keeping all your data in the less than pretty 11x17 version.
Update/sort that whenever required.
Then build your pretty version whenever you want to print.
But remember, the pretty version is just for reporting uses--not for updating.
Linda L wrote:
I have a huge spreadsheet that currently fits comfortably on an 11 x 17" page
making it difficult to work with and understand....just too big. I'd like to
make the spreadsheet fit on an 8.5 x 11" (landscape) page by stacking fields.
This is marketing pursuit data so most fields hold text. When I stack the
fields some fields must be merged. So far...not tough....I have a beautiful
spreadsheet with all the data in a convenient format, easy to understand.
The problem is sorting the first field (priority) per field grouping....can't
sort because of merged fields. I tried doing the table in word using form
fields...same problem with sorting because of merged fields. Any ideas?
--
Dave Peterson
|