Re: Printing/Forms

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Anne Troy (newsgroups_at_vbaexpress.com)
Date: 09/29/04 

Date: Wed, 29 Sep 2004 12:20:06 -0400

Hi, Allie. Try Word Mail merge.
You can print any way you like.
**** Hope it helps! ****

~Dreamboat
Excel VBA Certification Coming Soon!
www.VBAExpress.com/training/
********************************
"Allie" <Allie@discussions.microsoft.com> wrote in message
news:959291C7-401A-4608-A547-879A6D3DDB57@microsoft.com...
> Hi
>
> I've been asked to present a suggestion for an issue we are having here.
>
> There is a spread***- 29 columns, with 188 individual rows.
>
> I have to suggest a method for data entry- easy enough, I'll just show
them
> how to use the form function.
>
> But more importantly, the data now is presented horizontally. ie if I were
> to print it, the data for each row would print across the paper. is there
> any way to keep the column headings where they are, but have the record
print
> the opposite way. (ie in excel there would be column headings, but on
paper,
> it would print verically and the column heading would now be a row
heading.
> ONe record per page.
>
> EXCEL
> ====
> NAME ADDRESS PROVINCE
> ALLIE 4 LONDON ONTARIO
>
> PRINT
> ====
> NAME ALLIE
> ADDRESS 4 LONDON
> PROVINCE ONTARIO
>
> Ideally, I would also create buttons so that I either launch a form to add
> new data, OR to print a record.
>
>
> I'm assuming I could probably create a macro to do it, but the question is
> 1- am I thinking correctly? is there an easier solution?
> 2-If I do have to do macros, am I capable? I really am a complete
beginnner
> when it comes to macros.
>
>
>
> I hope I've presented that clearly.
>
>

Quantcast