I have a number of users that need to enter data into excel on and off during the day and view the results of theirs and and others' data. At the end of the week i produce a coplex set of reports.
Excel's sharing ability is too poor for this but it is the easiest way for me to crunch the data for the reports.
Can I use access for entering data and displaying it and then get my excel workbook to use the access data for the reports?
I realise it could all be done in access but I'm an access newbie and I'll find it far easier to do my reports in excel.
Would this be possible?
Excel's sharing ability is too poor for this but it is the easiest way for me to crunch the data for the reports.
Can I use access for entering data and displaying it and then get my excel workbook to use the access data for the reports?
I realise it could all be done in access but I'm an access newbie and I'll find it far easier to do my reports in excel.
Would this be possible?