Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to have a record number change for every record | Excel Discussion (Misc queries) | |||
Open new record with selected fields from previous record | Excel Discussion (Misc queries) | |||
Keep a static record of data | Excel Discussion (Misc queries) | |||
Merging data of the same record | Excel Discussion (Misc queries) | |||
Record data on two lines | Excel Discussion (Misc queries) |