$$Excel-Macros$$ "Calculation is incomplete. Recalculate before saving?"

2016-11-10 Thread mortgageprogrammer
Dear Excel fans: Have you ever encountered such an alert before saving a spreadsheet? I have only gotten it once I switched from Excel 2010 to Excel 2016. Is it due to custom functions in conditional formatting? Thank you in advance!! M.P. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

$$Excel-Macros$$ Best Book to Migrate from Excel 2010 to Excel 2016

2016-09-09 Thread mortgageprogrammer
Dear Experts: What would you recommend to be the best book or website to learn Excel 2016 (and VBA) shortcuts? Thank you very much in advance!! M.P. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

$$Excel-Macros$$ Circular Reference - Algebra Challenge

2016-05-25 Thread mortgageprogrammer
Dear Experts: See the attached spreadsheet. I have a cell which is a percentage of a final number; and the final number is calculated as the maximum of two sums, while the percentage cell is an item/element of one of the sums. Is it possible to reconcile this by using an algebraic formula for th

$$Excel-Macros$$ VBA 2016 Compatibility with VBA 2010 (Missing Reference)

2016-05-17 Thread mortgageprogrammer
Dear Experts: I would like to have spreadsheets shared between a 2010 Excel user and a 2016 Excel user. The issue is that when a 2016 Excel user saves a spreadsheet; a 2010 Excel user will not be able to open it and run macros which use Word objects. When the user tries to run one of these macro

$$Excel-Macros$$ Nesting And/OR/or other functions within an Index-Match array formula

2016-04-11 Thread mortgageprogrammer
Dear Experts: In the attached spreadsheet, I have an array formula which I would like to increase its dynamics. Currently, cells C7 and C8 require exact matches for "term", but is it possible to make the formulas in C7 and C8 return results for any "term" value above 12 just as it would return

Re: $$Excel-Macros$$ Shortening an Excel Sheet

2016-02-23 Thread mortgageprogrammer
Thank you so much, Paul, for sharing your expertise with me. You made it very clear. M.P. On Tuesday, February 23, 2016 at 12:06:14 PM UTC-5, Paul Schreiner wrote: > This version of Excel has 16,384 columns and 1,048,576 rows. > The worksheet you've provided has those "extraneous" cells hidden.

Re: $$Excel-Macros$$ Shortening an Excel Sheet

2016-02-23 Thread mortgageprogrammer
Thank you so much, Norman, for sharing your expertise with me. M.P. On Monday, February 22, 2016 at 7:31:14 PM UTC-5, Norman wrote: > Select the upper left corner of the worksheet. Above row 1 and the the > left of column A. This will select the entire worksheet. Right click any of > the row nu

$$Excel-Macros$$ Re: Excel Formula Returning Different Value if User Clicked Checkbox

2015-12-24 Thread mortgageprogrammer
Suresh: This is perfect!!! Thank you Sorry for the delayed thank you, M.P. On Thursday, December 17, 2015 at 1:59:30 AM UTC-5, Suresh Kumar B wrote: > Hi, > > Herewith i have attached the solved excel. > > If you have any questions, Please let me know. > > *Thanks & Regards,* > *Suresh

$$Excel-Macros$$ Excel Formula Returning Different Value if User Clicked Checkbox

2015-12-14 Thread mortgageprogrammer
Dear Experts: Do you know if it is possible to write a formula, then make a checkbox, whereupon the formula will return different results based on the user's choice of checking the box or not. Please see the attached example. Thank you!! M.P. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Ex

$$Excel-Macros$$ Re: VBA (Excel) Transferring Data to Website

2015-12-09 Thread mortgageprogrammer
Mandeep baluja: Thank you so much for writing the Macro! I have a question: How did you come up with the names of the ElementIDs in the web page? You can name them what you want? How does Excel know which field in the web page you are referring to? Thank you!! On Wednesday, December 9, 2015 at

$$Excel-Macros$$ Re: VBA (Excel) Transferring Data to Website

2015-12-09 Thread mortgageprogrammer
Mandeep Baluja: You are an EXPERT. This is beautiful!! Thank you! M.P. On Wednesday, December 9, 2015 at 5:23:35 AM UTC-5, Mandeep Baluja wrote: > > Check this updated Attachment !!! > > Regards, > Mandeep baluja > https://www.facebook.com/groups/825221420889809/ > -- Are you =EXP(E:RT) or =

$$Excel-Macros$$ VBA (Excel) Transferring Data to Website

2015-12-08 Thread mortgageprogrammer
Dear Experts: Does anyone know if VBA can input data from a spreadsheet onto a web page? Can the data in the attached spreadsheet be automatically populated into the following page? https://www.defeasewithease.com/ Thank you very much, I respect you expertise, M.P. -- Are you =EXP(E:RT) or

$$Excel-Macros$$ Excel VBA data transfer to Website

2015-12-02 Thread mortgageprogrammer
Dear Experts: Do you know if Excel VBA has the capability to automate the transfer of data from a spreadsheet to a website (a web based database)? I have heard that Excel's API may be able to do it. Is that so? Thank you!! -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna b