Here's what I'm trying to do:
Forecast profit and losses, depending on new projects acquired and schedules of income and expenses associated with each project.
Here's how I'm trying to do it:
I have created a user-interface on my first page of excel. Here, a user can input the data without needing to open the database worksheet (and it's more user-friendly with little calculations to help them estimate what dates to connect to income or expenses).
I understand all the math-related aspects of the program already, it's mostly just algebra 1 or pre-algebra really. It's not the math I'm having problems with.
My problem/s:
1) The number of dates associated with income and expenses is variable. How do I copy all of the lines from the user interface into the next worksheet for data storage without copying any empty lines? (eg, user only needs 3 dates, but max is 8, if I copy the whole block and insert (with a macro), there will be 5 blank lines on the data storage worksheet).
2) I can retrieve data using the interface by doing a filter macro that will copy all relevant data from the data storage sheet back into the user interface page. However, how do I allow the user to change/delete/modify/add to that particular set of data while ensuring all the old data has been erased or changed appropriately? (deleting all of it in the data storage would probably be easiest, but how can I do that as a macro when the user hits the button to "Save new changes").. Also, I can identify a particular set of data by the project's name that will be tagged to each individual expense/ income (it's how I can filter and retrieve a particular project's income and expenses).
I know I could accomplish the functionality of the program without the user interface involved. The only reason I want the interface is that the program will become a little complicated and will be used by other people who won't know that much about how to use excel. By creating the user interface with a bunch of macro buttons, they will be less likely to mess the data up.
Does anyone have any suggestions on how to do this? I've already created the UI, but haven't linked it yet to the data storage sheets. As such, I'm pretty flexible with suggestions.
Bookmarks