LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
rjr rjr is offline
external usenet poster
 
Posts: 4
Default Using Excel as a database and need macro or vba to take data entered on one tab and update the database by adding to the next avail row

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Update Excel Database via Access Main Database with a script Finnbar New Users to Excel 2 November 3rd 08 07:24 PM
how to update a Batabase with data from another database Tom Ogilvy Excel Programming 0 August 3rd 05 09:09 PM
database to store data entered from a spreadsheet? Dan B Excel Programming 4 November 19th 04 09:15 PM
Adding data from Excel sheet to Access database William Francis Excel Programming 2 July 29th 04 02:43 PM
Help with macro to update list (database) wcmar10 Excel Programming 0 August 5th 03 12:47 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"