Thread: 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
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
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 rjr

Start here
http://www.rondebruin.nl/copy1.htm

Post back if you need more help

--
Regards Ron De Bruin
http://www.rondebruin.nl



"rjr" wrote in message . ..
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



Reply With QuoteReply With Quote