Save a Form in Excel: Podcast #1272
Posted by admin in Data Entry Tuesday, 8 November 2011 06:44 2 Comments
Kim has designed a simple data entry spreadsheet and would like to have a way to paste the data into the next empty row of a database worksheet she has created. In Episode 1272, takes a look at how to finesse the macro recorder to solve this problem.
To Kim i would recommend learning some vba. Macro recording is not worth the headaches.
Love it. I wasn’t aware that the relative reference could be changed after recording. This will be so helpful….Thanks Bill. Another great one.