Keeping formula in Cells after "data refresh"
Hopefully someone can help me out. I have an excel spreadsheet that, when opened pulls data from a database, and is formatted on the spreadsheet. In the middle of the columns of data I retrieve there are two columns that have formulas in it, that I put in manually.
I want to put those forumlas in one time and that's it, but when I close the spreadsheet it deletes all the information and when re-opened the formulas are gone.
The spreadsheet is a "public" sheet so that people in the office can see the progress and stats of transplants, the formula part is a very important.
Can anyone help me or tell me how to keep the forumlas in the spreadsheet?
Did that make sense? let me know if I can give you more information.
If your workbook is down loading information automatically from a database when opened then any formulas you have entered previously will be overwritten. If the formulas are always the same and located in the same place then a macro could be written to automatically reload the formulas after the data has been loaded. Can you post what the formula are?
I sure can post the formulas. I have attached a modified spreadsheet that has the forumlas in the columns and shows how they are calculated. The two colunms are in the middle, and the data pulling from the database populates the cells around those two columns.
It used to save the formulas in those particular columns but I did something to it and now the forumlas won't save.
Thanks for the help!!
Macro Works great!
I worked the macro, put a keyboard short-cut on it and it works great! I can't believe I didn't think about the Macro...oh well that is what I joined for forum for.
Have a great day! Thanks again!
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1