Hi, I have prepared finance related templates in excel. The file has around 20 sheets. I want to convert this into a proper software. Need your guidance. Thank You.
Hi, I have prepared finance related templates in excel. The file has around 20 sheets. I want to convert this into a proper software. Need your guidance. Thank You.
Without seeing your templates it is impossible to give you step by step instructions, and nobody here, where time is given for free, is likely to do that anyway.
However, in broad terms, think of your workbook as a database, each sheet as a table and each column as, well, a column in that table.
So design your database accordingly, where each sheet in your workbook is a table.
Good luck and I hope that helps you get started.
_______________
Floyd Emerson
Business Intelligence Consultant
Melbourne, Victoria, Australia
What kind of templates are they & what makes them software?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks