Hi, I have a large Excel file with many data Sheets and Complex formulas. The last Sheet is a price simulator. When I input certain number of product, It shows me below the simulated cost. But the problem is that the Excel must be private, except the last Price simulator Sheet which should be public or several people using it. So my idea was making like Access FORM. Or import data from Excel to Acces....but I think it's a bad idea. So What do you suggest me?
Excel o Access? Will all complex formulas I use in Excel can work in Access too? The SQL is same or more powerful than Excel?
Or how to just "show" the last excel sheet like a GUI programm. Or Make an interfacte to connect and show the specific sheet for data input-simulation.
Thanks in advance,
Bookmarks