VBA

The UK's most regular instructor-led training courses.
Training information: microsoft-excel-courses · Advanced.excel · VBA courses London UK

Resolved · Low Priority · Version Standard

VBA

Matthew has attended:
Excel Advanced course
Excel VBA course

by - delegate Matthew [2 posts] (2008 Feb 15 Fri, 16:08) Reply

How can i get around session ID problem, which means a web query only works once?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Jul 8 Tue	Bloomsbury	0	FULL
2003/XP	2008 Jul 8 Tue	Bayswater	1	book now	£195	£205
2003/XP	2008 Jul 9 Wed	Bloomsbury	3	book now	£210	£215
2003/XP	2008 Jul 15 Tue	Bloomsbury	3	book now	£210	£215
2003/XP	2008 Jul 15 Tue	Tooting	0	FULL
2007	2008 Jul 16 Wed	Bloomsbury	7	book now	£202	£224
Full Schedule: See all 160 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: VBA

by - trainer Rich platinum contributer [654 posts] (2008 Apr 4 Fri, 10:29) Reply

Hi Matthew,

As this is a duplicate question, I'll continue answering your question here.

I'll mark this post as resolved so we can concentrate on just the one post.

Regards, Rich

· Microsoft Office and the Small Business: Part 1 Excel
· Microsoft Excel Courses Teach Advanced Macro Techniques
· Microsoft Excel Training - Numerical excellence for all
· Basic Excel Training
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel

Please browse our web site to find out more about
microsoft-excel-courses and other Microsoft training courses.

Excel tip:

Entering text in Multiple Worksheets

If you have a number of worksheets in a workbook that require the same information (data or tables) on each worksheet, this can be done as follows:

Hold down the Ctrl key and click one or more of the additional worksheet tabs (i.e. Sheet2, Sheet3, etc).

In your mainsheet (Sheet1) enter the required data or design a table.

When done 'Click' on the other sheet tabs and you will see that the information entered in Sheet1 is on all the other selected worksheets.

NB Do not forget to deselect the worksheets - otherwise you may add data to the main worksheet and all the selected worksheets will also have that data!

View all Excel hints and tips