Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
keeping track of a range of cells in another spreadsheet or access database
Hi, Tom Ogilvy many thanks for your help on my other posting, my next
question maybe possible and I hope you or others can point me in the right direction. Having created a spreadsheet I want to output a range of cells to either another spreadsheet or access database and keep them catalogued by date order, a value held in a specific cell on the original spreadsheet. I be changing theses cells and date cell regularly and need to over write the ones held in the other spreadsheet, therefore if its a new date another entry would be added to the other spreadsheet or access database but if its a date already entered then the cells linked to that date would be over written with the new values. Does that make sense ? Obviously I will need to have a search function that looks to see if the date exists, if not enter the date and linked cell values, if it does then move to that position and overwrite the values. Hopefully someone will be able to make sense of my rantings and offer me some advice, guidance, or if possible some coding examples. Regards, Colin *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I track users who access a spreadsheet? | Excel Discussion (Misc queries) | |||
Converting Excel spreadsheet with formulae to Access database | Excel Discussion (Misc queries) | |||
Make an Access Database out of Excel spreadsheet | New Users to Excel | |||
Inserting an Access database into a spreadsheet? | Excel Programming | |||
How to save an Excel range into an Access Database | Excel Programming |