Excel or Access
Hello all readers
I have developed a pricing spreadsheet on Excel. Although I've probably used overcomplicated formulae, it produces what I need to, so I'm relatively happy with it. The trouble is that the entry onto the spreadsheet isn't the most user friendly.
I was hoping to convert this into an Access Database, but basically want to maintain all the Excel formulae. Is the transition from Excel to Access that easy.
Basicaly, I want all the benefits of Excel's formulae, but with the benefits of the displays in Access and ease of entry that is Access. I want people to be able to enter on tables on Access but then calculations get done to the entries and calculated results shown on Access.
Am I being too greedy?