Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have one sheet of excel used to enter data into cells arranged as an input form. All these entries are transferred to a second sheet that I use as a merge file for a couple of WORD documents. Right now it functions as a single entry database that is only good for one data record. I'm looking for a way to 1. Take all data from this worsheet tab and save it into the next available row on my database. Eventually I need to add row 2 row 3 row 4 and so on, and this could be the information source for my flat database. 2. Be able to go to a specific record on the database sheet and alter the data to permanently change it. Basically I would like to have a macro to SAVE - NEXT - PREVIOUS - PRIOR the database portion consists of about 75 columns for each record. Any help would be appreciated if this is possible. Hope someone has some code or a solution. Thank you Bob Reynolds |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Update Excel Database via Access Main Database with a script | New Users to Excel | |||
how to update a Batabase with data from another database | Excel Programming | |||
database to store data entered from a spreadsheet? | Excel Programming | |||
Adding data from Excel sheet to Access database | Excel Programming | |||
Help with macro to update list (database) | Excel Programming |