ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Need help autopopulating next new record with previous record data (https://www.excelbanter.com/excel-programming/278434-need-help-autopopulating-next-new-record-previous-record-data.html)

Harry S[_3_]

Need help autopopulating next new record with previous record data
 
Hi -

I was asked to create a spreadsheet with a form that automatically
populates the next blank record with certain data values from the
previous record. The purpose is to save keystrokes. I've created a JWalk
Enhanced Data Form with some drop downs, but do not know how to get the
previous record to automatically recur in the next new record for
certain fields. Thanks in advance for any input.

Regards,

Harry

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Dave Ramage[_2_]

Need help autopopulating next new record with previous record data
 
Harry,

This would probably be a fairly simple modification, but
you'd have to get access to the VBA code in order to
change it. This is protected, though you can get the
password for $20 from John's web site.

Cheers,
Dave.
-----Original Message-----
Hi -

I was asked to create a spreadsheet with a form that

automatically
populates the next blank record with certain data values

from the
previous record. The purpose is to save keystrokes. I've

created a JWalk
Enhanced Data Form with some drop downs, but do not know

how to get the
previous record to automatically recur in the next new

record for
certain fields. Thanks in advance for any input.

Regards,

Harry

*** Sent via Developersdex http://www.developersdex.com

***
Don't just participate in USENET...get rewarded for it!
.


Harry S[_3_]

Need help autopopulating next new record with previous record data
 

Thanks Dave!

That's the news I wanted to hear. I just purchased the code two nights
ago and am becoming familiar with it. Any idea what good code might
look like? Thanks in advance for any input.


Regards,

Harry

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


All times are GMT +1. The time now is 10:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com