Excel -- Saving Form to Database: Episode 1504

Описание: Microsoft Excel Tutorial: Using Excel as a Data Entry Form - Part 2 | John Lythe's Clever Idea Simplifies VBA Code.

Welcome to another episode of the MrExcel podcast. In this episode, we will continue our discussion on using Excel as a data entry form. In the previous episode, we talked about the concept and how it came from the Excel gurus group on LinkedIn. Today, we will explore a clever idea suggested by John Lythe from New Zealand, which simplifies the VBA code and makes the process even more efficient.

John's idea is to use row 100 as a reference point and build formulas that put the fields back in order. This eliminates the need for the code to figure out the correct order, making it much simpler. The VBA code now only needs to move the range A1 to G100 to the next row, instead of selecting individual fields. This not only saves time but also makes the code more manageable.

But that's not all, our discussion on the Excel gurus group also brought in other interesting ideas from members like Jim Palmer and [Prem – 01:19]. They shared their methods for bringing back old records for editing, making this data entry form even more versatile. If you're interested in learning more about this topic, I have included a tinyurl in the description where you can check out the full discussion.

Using Excel as a data entry form is a great way to simplify the process and avoid the need for everyone to have access to a database. It's a useful tool for small businesses or teams who need to manage data without investing in expensive software. So, if you're looking for a simple and efficient way to enter and manage data, be sure to check out this episode and join the discussion on the Excel gurus group. Thank you for tuning in, and we'll see you next time for another netcast from MrExcel.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...


Table of Contents:
(00:00) Excel As A Data Entry Form Part 2
(00:18) Introduction of John Lythe's idea
(00:42) Other contributors to the discussion
(01:02) Clearing fields and other methods mentioned
(01:28) Conclusion and invitation to check out the discussion
(01:38) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Clearing fields
Editing old records
Excel As A Data Entry Form Part 2
Excel gurus group at LinkedIn
Excel worksheet as a data entry form
Learn Excel From MrExcel
Podcast Episode 1504
Simplifying VBA code
Using Excel as a database entry form
Using row 100 for formulas


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...


John from New Zealand offers an improvement to Thursday's podcast about creating a Data Entry form on a spreadsheet. Today, in Episode #1504, Bill applies the tip from John to improve the VBA code for this Database Form routine!

...This episode is the video podcast companion to the book, "Learn Excel 2007 through Excel 2010 from MrExcel". Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book!

"The Learn Excel from MrExcel Podcast Series"

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!