Learn How To Use Data Mapping to Map Data From Forms To Tables [GREAT FOR VBA BEGINNERS]

In this week’s training, I will show you how to use data mapping to create Excel forms.

⬇DOWNLOAD THIS WEEKS WORKBOOK FREE:

EXCEL COURSES:

EXCEL PRODUCTS:

TIMESTAMPS:
0:00 – Introduction
0:36 – Overview
4:01 – Worksheet Design
36:59 – Browse for Picture
43:38 – Display Picture
57:20 – Save and Update Product
1:12:40 – Add New Product
1:17:09 – Load Product
1:21:48 – Change Event Worksheet
1:25:38 – Delete Product

Follow me on my Social Media Accounts:

About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.

Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:

New Training Video Uploaded Every Tuesday And Saturday!
Thank you very much for your continued support,
Randy Austin
#DataMapping #ProductManagement #ExcelVBATables #ExcelVBA

[TradShowTom]

This training changed my life. I use data mapping all the time now in everything I build. I needed a way to create apps in Excel that end users wouldn't mess up by overwriting formulas and breaking the app. This was my solution. Absolute gamechanger.

[joemanflyer]

I’ve never used Excel for this … this will work for my company

[michaelsvenson]

A true wizard, I told you before that all your videos are amazing, easy to understand with all your explanation of what the code is doing and why it's there. Great job. 🙂

[fhozouri]

I can't believe it. I was always thinking when I am going to see a data mapping training. I woke up this morning, here what I see. Thank you

[VS-rhrq]

Wow! All these topics are covered in almost all your weekly videos but this is the most comprehensive and best thing it cleared all issues. THANKS

[mkhanapathan]

Thank you for yet another session that one can learn so much from and apply it in practical terms. One question would be, correct me if I am wrong but the column numbers offset could be set as variables within code whereby removing the need for any being on the main sheet/form.

[Posnaniensis]

Randy,
Been watching your tutorials for some time, to me - a revelation! You do know you do a great job, don't you? Actually, you are one of a few who cares for such complex AND complete A-Z solutions.
If you happen to have a spare minute, it'd be great to hear an advice from you: whenever you mention a sample of, say, 3 or 4 items/clients to be picked by NAME, there's no problem with that (like: oranges, apples, carrots - a short list, an un-alfabetic order is not a problem here). Problem arises when a customer/ items list gets much longer thus almost impossible to be picked by name, for such a list is not sorted A-Z. Items are fixed to given rows in excel DB, and in a drop-down menu they are presented in such an order (Oranges, Apples, Carrots and not: Apples, Carrots, Oranges).

Is there a way to make a 'by-name' sorting/picking more user friendly?
Greetings from Poland. A far, far away land.
Chris (much Shrek-alike by the looks...)

[MrDiabolicmuffin]

This let me create an awesome spreadsheet at work... blew everyone’s mind! Definitely helped get me noticed... thank you!!!

[porvikvlogs]

Hi Randy

I am Really Learnt Lots of Excel Projects from your Channel, I am a Big Fan of your Excel Work - My Daily Rotuine is watching your Videos atleast 1 per day, as a Data Analyst & MIS handler - Your Videos are Helping me a Lot - Thank you for your Valuable Information sharing through these videos 🤩

[Waterfox]

Hello,
I love the way you are teaching this program. I am in need of setting up a grave registry and this is the best form that I have seen in terms of ease.

[c.e.bingham]

This is a great real life exercise. Thanks for putting this together.

[siushuenerhui]

Excellent training!!! Gain better understanding on the concept of data mapping 😀

[XLSavvy]

Well Randy this video helped me alot in making my reports and formats more quickly as i always struggeled on data mapping but now i feel more comfortable in doing all this especially reports with pictures and attachments. Thank you so much for This :)

[gerardbakker]

That's excellent training Randy, learning lots, thanks

[alkolff]

Thank you so much Randy. Truly a blessing. And a great concept idea on how to map.

[ElectromecanicaIndustrial]

Amazing, I learn a lot

Now i need to install Autohotkey and replicate this training

[wayneedmondson]

Hi Randy. Looks awesome! Can't wait. I've noodled with your data mapping techniques through some of your other videos. Looking forward to a dedicated class on the subject :)) Thumbs up!!

[yahya_yg]

Realy liked the data maping Thanks mr Randy i hate long Edit or save code wich was without a loop :
Range = Range until N line

[sinnovatetechnologies]

Good job my friend Austin. Kindly think of preparing a fixed asset management tool with features like depreciation, amortization etc

[andreasgruber]

Excellent tutorial Randy!
Very usefull for me.

I often have similar clients/products.
In this scenario I would >>> Change the Name and + delete the Product ID = and it makes a copy of all the specifications, but with a new ID and new NAME.
What would it look like, to have a separate Button for that "NEW CLIENT".
For this I tried the following:

End If
If .Range("E7").Value = Not Empty Then 'Remove existing ID
.Delete


End If
If .Range("B6").Value = Empty Then 'New Client-ID
.Range("E7").Value = .Range("B7").Value 'Get Client-ID
ProdRow = + 1
DATENBANK.Range("A" & ProdRow).Value = .Range("B7").Value 'Kunden-ID

Unfortunately, it does not create a new product/Client.
It just changes the NAME of the exixting one.

Any ideas?

Thanks for all the good work.