Great tricks when loading Files From Folder if sheet names are different

Access Analytic October 27, 2023
Video Thumbnail
Access Analytic Logo

Access Analytic

View Channel

About

Amazing Excel and Power BI Solutions. Perth, Western Australia. Our aim is to help you make decisions with confidence. Let us know if there's topics you'd like to cover and please subscribe and click the notification item to keep informed when we release new videos. About Us... Jeff Robson, Wyn Hopkins are the directors of Access Analytic Jeff is the founding Director and Principal Business Analyst at Access Analytic Solutions. He has over 20 years’ experience in chartered accounting, business management and consulting. Wyn is a Microsoft MVP and was once upon a time a Chartered Accountant with PricewaterhouseCoopers in the UK. He published the book Power BI for the Excel Analyst (a beginners guide to Power BI) in July 2022: https://pbi.guide Find out more about us and the team here https://accessanalytic.com.au/about-us-2-2/ Both Jeff and Wyn would love to connect up with you on LinkedIn https://www.linkedin.com/in/wynhopkins/ https://www.linkedin.com/in/jeffrobson/

You May Also Like

Empower Your Mornings

AI-recommended products based on this video

Loading...
zicor Kids Smart Watch Gift with Dual Camera, Puzzle Games, Pedometer, Music Player, Video Recorder, Parental Control, Alarm Clock, HD Touch Screen, Toy Smart Watch for Boys and Girls Age 4-12 (Pink)
Best Seller

zicor Kids Smart Watch Gift with Dual Camera, Puzzle Games, Pedometer, Music Player, Video Recorder, Parental Control, Alarm Clock, HD Touch Screen, Toy Smart Watch for Boys and Girls Age 4-12 (Pink)

(286)
$49.99
PrimeFREE delivery Sat, Jun 14
200+ bought in past month
Loading...
Nespresso Vertuo Pods, Discovery Bestsellers Mixed Pack of 60 capsules - Compatible with Vertuo coffee maker, Recyclable pods

Nespresso Vertuo Pods, Discovery Bestsellers Mixed Pack of 60 capsules - Compatible with Vertuo coffee maker, Recyclable pods

(3)
$77.40
FREE delivery Mon, Aug 25
500+ bought in past month
Loading...
Christmas Bath Bombs Set for Kids,Boys & Girls Stocking Stuffers Gift, Handmade 6 Fun Organic for Children, Gentle Formula Creates, Relaxing Aromas for Women
Best Seller

Christmas Bath Bombs Set for Kids,Boys & Girls Stocking Stuffers Gift, Handmade 6 Fun Organic for Children, Gentle Formula Creates, Relaxing Aromas for Women

(53)
$13.99
FREE delivery Fri, Oct 10 on your first order
200+ bought in past month
Loading...
Shower Steamers Aromatherapy 8 Pack Gifts for Women & Men Bath Bombs, Organic Eucalyptus & Menthol Essential Oil,Birthday Gifts for Wife & Husband Spa Relaxing, Travel Essentials Aromatherapy

Shower Steamers Aromatherapy 8 Pack Gifts for Women & Men Bath Bombs, Organic Eucalyptus & Menthol Essential Oil,Birthday Gifts for Wife & Husband Spa Relaxing, Travel Essentials Aromatherapy

(54)
$13.99
FREE delivery Thu, Sep 11 on your first order
100+ bought in past month
Loading...
HLDIRECT 47 Inch Gaming Desk with LED Lights, Home Office Gamer Desk, Ergonomic Computer Table with Large Carbon Fiber Desktop, Computer Desk with Cup Holder & Headphone Hook for Home Office, Black

HLDIRECT 47 Inch Gaming Desk with LED Lights, Home Office Gamer Desk, Ergonomic Computer Table with Large Carbon Fiber Desktop, Computer Desk with Cup Holder & Headphone Hook for Home Office, Black

(591)
$107.99
FREE delivery Thu, Jun 26
Loading...
SEVEN WARRIOR Gaming Desk with LED Lights & Power Outlets, 55" Computer Desk with Monitor Shelf, Home Office Desk with Cup Holder and Headphone Hook, Ergonomic, Carbon Fiber Surface Black

SEVEN WARRIOR Gaming Desk with LED Lights & Power Outlets, 55" Computer Desk with Monitor Shelf, Home Office Desk with Cup Holder and Headphone Hook, Ergonomic, Carbon Fiber Surface Black

(693)
$109.99
FREE delivery Thu, Jun 26
Loading...
Cervical Neck Pillow, Memory Foam Pillows for Neck and Shoulder Pain Relief, 2 Heights Ergonomic Pillow with Breathable Ice Silk Cover, Neck Support Pillow for Side Back Stomach Sleepers, Odorless OEKO-TEX STANDARD 100

Cervical Neck Pillow, Memory Foam Pillows for Neck and Shoulder Pain Relief, 2 Heights Ergonomic Pillow with Breathable Ice Silk Cover, Neck Support Pillow for Side Back Stomach Sleepers, Odorless OEKO-TEX STANDARD 100

(362)
$55.99
Loading...
Delyoly Neck Pillow Memory Foam Pillow, 2 in 1 Cervical Pillow for Neck Pain Relief, Ergonomic Neck Support Pillows for Side Back Stomach Sleepers with Comfortable and Breathable Pillowcase

Delyoly Neck Pillow Memory Foam Pillow, 2 in 1 Cervical Pillow for Neck Pain Relief, Ergonomic Neck Support Pillows for Side Back Stomach Sleepers with Comfortable and Breathable Pillowcase

(107)
$49.99
Prime
2K+ bought in past month
Loading...
Mkicesky Orthopedic Cervical Pillow for Neck & Shoulder Pain – Cooling Memory Foam Pillow with Ergonomic Center Cradle Design – Reading Pillow Ideal for Side, Back & Stomach Sleepers – Steel Blue

Mkicesky Orthopedic Cervical Pillow for Neck & Shoulder Pain – Cooling Memory Foam Pillow with Ergonomic Center Cradle Design – Reading Pillow Ideal for Side, Back & Stomach Sleepers – Steel Blue

(4)
$40.79
FREE delivery Wed, Sep 24
600+ bought in past month
Loading...
TREKOLOGY ALUFT Pro Inflatable Camping Pillow – Memory Foam Layer for Quiet Sleep – Removable Washable Cover – Ergonomic, Lightweight 245g – Grey – Travel, Hiking, Backpacking

TREKOLOGY ALUFT Pro Inflatable Camping Pillow – Memory Foam Layer for Quiet Sleep – Removable Washable Cover – Ergonomic, Lightweight 245g – Grey – Travel, Hiking, Backpacking

(12)
$29.99
FREE delivery Mon, Jul 7 on your first order
Loading...
ASUS ZenScreen 15.6” 1080P Portable Monitor (MB16ACVR) - Full HD, IPS, Eye Care, Flicker Free, Blue Light Filter, Kickstand, USB-C Power Delivery, for Laptop, PC, Phone, Console, Antibacterial Surface

ASUS ZenScreen 15.6” 1080P Portable Monitor (MB16ACVR) - Full HD, IPS, Eye Care, Flicker Free, Blue Light Filter, Kickstand, USB-C Power Delivery, for Laptop, PC, Phone, Console, Antibacterial Surface

(2,000)
$209.00
FREE delivery Aug 11 - 13
Loading...
Desnuage Teardrop Aquamarine Hoop Earrings Sterling Silver Dangle Light Blue Earrings for Women

Desnuage Teardrop Aquamarine Hoop Earrings Sterling Silver Dangle Light Blue Earrings for Women

(1)
$19.99
FREE delivery Sun, Jul 6 on your first order
Loading...
Watforsh Big Blue Leaf Silver Dangle Earrings for Women Boho Earrings Drop with Light Blue and Beige Bohemian Tropical Style Plant Dangling for Gift

Watforsh Big Blue Leaf Silver Dangle Earrings for Women Boho Earrings Drop with Light Blue and Beige Bohemian Tropical Style Plant Dangling for Gift

(1)
$20.99
FREE delivery Sun, Jul 6 on your first order
Loading...
IPROKKO Laptop 14 inch Privacy Screen Filter for Hp/Dell/Thinkpad/Lenovo/Samsung/Asus/Sony, 16:9 Aspect Ratio Removable Anti Blue Light Glare Protector, 14 in Privacy Shield

IPROKKO Laptop 14 inch Privacy Screen Filter for Hp/Dell/Thinkpad/Lenovo/Samsung/Asus/Sony, 16:9 Aspect Ratio Removable Anti Blue Light Glare Protector, 14 in Privacy Shield

(137)
$31.99
FREE delivery Tue, Jun 17 on your first order
Loading...
2 Pack Magnetic Wireless Charger 15W Fast Mag-Safe Charger Stand Compatible with iPhone 16/15/14/13/12 Series Wireless Charging Pad for AirPods 3/2/Pro 2/Pro White Portable Mag Safe Kickstand

2 Pack Magnetic Wireless Charger 15W Fast Mag-Safe Charger Stand Compatible with iPhone 16/15/14/13/12 Series Wireless Charging Pad for AirPods 3/2/Pro 2/Pro White Portable Mag Safe Kickstand

(31)
$24.69
FREE delivery Sat, Jun 14 on your first order
500+ bought in past month
Loading...
Magnetic Wireless Charger for iPhone: Fodable 3 in 1 Charging Station for Multiple Apple Devices - Travel Charging Pad Dock for Apple Watch iPhone 16 15 14 13 12 Pro Max Plus & Airpod Global Recycled Standard

Magnetic Wireless Charger for iPhone: Fodable 3 in 1 Charging Station for Multiple Apple Devices - Travel Charging Pad Dock for Apple Watch iPhone 16 15 14 13 12 Pro Max Plus & Airpod Global Recycled Standard

(656)
$49.99
PrimeFREE delivery Sat, Jun 14
100+ bought in past month
Loading...
Wireless Earbuds, 2025 Bluetooth 5.4 Bass Stereo Headphones with 4 ENC Mic, 48H Playback Ear Buds with Charging Case LED Display,Sport Earphones IPX7 Waterproof for Phone, Android, Pad, White

Wireless Earbuds, 2025 Bluetooth 5.4 Bass Stereo Headphones with 4 ENC Mic, 48H Playback Ear Buds with Charging Case LED Display,Sport Earphones IPX7 Waterproof for Phone, Android, Pad, White

(38)
$27.99
Prime
Loading...
Monster Persona SE ANC Active Noise Cancelling Headphones, Bluetooth Headphones Over Ear with 60H Playtime, HiFi Stereo Audio, Deep Bass, Wireless Headphones for Office

Monster Persona SE ANC Active Noise Cancelling Headphones, Bluetooth Headphones Over Ear with 60H Playtime, HiFi Stereo Audio, Deep Bass, Wireless Headphones for Office

(2)
$59.99
FREE delivery Tue, Nov 11
200+ bought in past month
Loading...
Monster Persona 6th ANC Active Noise Cancelling Headphones, Bluetooth Headphones Over Ear with HiFi Stereo Audio, 60H Playtime, 3 EQ Modes, Bluetooth 6.0, Wireless Headphones for Travel Work, Black

Monster Persona 6th ANC Active Noise Cancelling Headphones, Bluetooth Headphones Over Ear with HiFi Stereo Audio, 60H Playtime, 3 EQ Modes, Bluetooth 6.0, Wireless Headphones for Travel Work, Black

(33)
$61.99
FREE delivery Sat, Nov 22
500+ bought in past month
Loading...
Bose QuietComfort Wireless Noise Cancelling Headphones, Bluetooth Over Ear Headphones with Up to 24 Hours of Battery Life, Moonlight Grey - Limited Edition

Bose QuietComfort Wireless Noise Cancelling Headphones, Bluetooth Over Ear Headphones with Up to 24 Hours of Battery Life, Moonlight Grey - Limited Edition

(12,251)
$269.00
FREE delivery Tue, Oct 14
Loading...
Monster Persona 6th ANC Active Noise Cancelling Headphones, Bluetooth Headphones Over Ear with HiFi Stereo Audio, 60H Playtime, 3 EQ Modes, Bluetooth 6.0, Wireless Headphones for Travel Work, White

Monster Persona 6th ANC Active Noise Cancelling Headphones, Bluetooth Headphones Over Ear with HiFi Stereo Audio, 60H Playtime, 3 EQ Modes, Bluetooth 6.0, Wireless Headphones for Travel Work, White

(23)
$61.99
Prime
Loading...
Figure 8 Fitness Resistance Band 3 Pcs, Elastic Rope Stretch Bands for Working Out, Foot, Leg, Arm, Back, Chest, Portable Home Office Training Exercise Stretcher for Yoga Pilates Physical Therapy

Figure 8 Fitness Resistance Band 3 Pcs, Elastic Rope Stretch Bands for Working Out, Foot, Leg, Arm, Back, Chest, Portable Home Office Training Exercise Stretcher for Yoga Pilates Physical Therapy

(2)
$15.99$8.90
FREE delivery Sun, Aug 10 on your first order
Loading...
Yes4All Aerobic Stepper Exercise Steps with Adjustable Height, Fitness Stepper for Home & Gym, Aerobics, Cardio, Weights, Yoga

Yes4All Aerobic Stepper Exercise Steps with Adjustable Height, Fitness Stepper for Home & Gym, Aerobics, Cardio, Weights, Yoga

(8,956)
$130.20$81.85
FREE delivery Sat, Jun 28
Loading...
ALONG FIT High Waisted Tummy Control Leggings for Women Yoga Pants with Pockets Workout Squat Proof Tights

ALONG FIT High Waisted Tummy Control Leggings for Women Yoga Pants with Pockets Workout Squat Proof Tights

(12,044)
$54.38
FREE delivery Thu, Sep 4
Loading...
65W USB-C/Type C Laptop Charger Power Supply Adapter for Lenovo Yoga Chromebook series,Thinkpad t480,Lenovo Yoga C930-13,Yoga S730-13,Yoga 920-13,Yoga 730-13,IdeaPad 730s-13,GX20P92530,ThinkPad X1 Carbon,with CA Power Cord

65W USB-C/Type C Laptop Charger Power Supply Adapter for Lenovo Yoga Chromebook series,Thinkpad t480,Lenovo Yoga C930-13,Yoga S730-13,Yoga 920-13,Yoga 730-13,IdeaPad 730s-13,GX20P92530,ThinkPad X1 Carbon,with CA Power Cord

(259)
$18.98$13.90
FREE delivery Sun, Jun 22 on your first order
100+ bought in past month