Export to Multiple Tabs in Excel (1 Viewer)

emz

New member
Local time
Today, 12:34
Joined
Nov 26, 2014
Messages
4
Hi All,

I was wondering if anyone could help me please?

I have information held in 3 different tables and I would like to extract this information to three different tabs in a singe Excel workbook - preferably in one step.

My access knowledge is fairly basic but I have been looking online and I can only find out how to do it using a VBA script - which is quite terrifying! Is there a simple way to do this?

Many thanks in advance
E
 

namliam

The Mailman - AWF VIP
Local time
Today, 13:34
Joined
Aug 11, 2003
Messages
11,696
If you want to do this in one step, the vba script is the way to go...

VBA isnt all that terrifying, just about as scary as water if you have Water fobia.... once you get your feet wet, you will love it and want more :)
 

Users who are viewing this thread

Top Bottom