Tom: Read my response. Jo wants to have a history of the data sent to access.
either Jo need to save the worksheets each day under a different name or
send different rows of data each day to the access db.
Maybe Jo should arrange worksheet so first day data is on rows 1 - 10.
Second day data is on rows 21 - 30. Third day data on rows 41-50. Then
select range of data to send to access before running macro. Macro will use
selected cells?
"Tom Ogilvy" wrote:
Sure, just write the code that writes the data to your database (assume Access)
http://www.erlandsendata.no/english/...php?t=envbadac
--
Regards,
Tom Ogilvy
"JoJo" wrote:
Folks:
I have a small spreadsheet consising of 5 columns & 10 rows of information.
Each day I manually update this spreadsheet so I end up with a new set of
data in the rows & columns.
But this means that the previous day's data is lost.
* Is there a way to create (then save) each day's data to a database so
that I can always go back to check on the old data ?
When I enter data in the spreadsheet, it should get stored in this database.
The spreadsheet is merely acting like a FORM thru which data gets sent to
the database.
Thanks,
Jo..