Dear,
I did all the changes as told me in previous mail and I have the following problems:-
Please correct me so, I can get the same result like "Zoom_in_Balance Sheet" in the "Zoom_in_ Profit & Loss.xlsm" file also. (Modified worksheed attached)
Dear,
With reference to the attachment, I customized the Please help me to correct the VBA code in “Zoom_in_Profit Loss” [Sheet6 (Income)] so get the result like the Balance Sheet Zoom. [Sheet6 (Income)] according to “Zoom_in_Balance Sheet” of [Sheet 1 (Balance Sheet)] but, it is not working...
Dear,
With reference to the attachment, I applied MAX; MIN; AVERAGE formula with selected range/ period manually according to the mentioned above (01-Mar-17 to 15-Mar-17).
The further request, I want to get the value automatically by the change of the period with the help of a formula.
Dear,
Received with thanks, I want to inform you that is not for others users, basically, my object is that I can do the copy of cell from here [column “A”] but, I could not do the post and insert here in the Column”A” from another sheet.
If I do the insert and post here in Column “A” its...
Dear All,
With reference to the attached sample file, I would like to show the “Error Alert” If we insert any data/statement in the column “A” with the help of Data Validation Tools.
Thanking you.
Dear AlanSidman,
Received with thanks for the quick reply, but, sorry to say it is not working. For the right answer, Please go through the following which I received from NARAYANK991.
Dear Narayan,
Thank full to you for elaborate the solution.
Dear All,
With reference to the attached sample file, the SUMPRODUCT formula at [column”4H”] to get the return of value with two conditions Total of BREAKFAST & PERIODICAL (18-Feb-2018 to 21-Feb-2018), but returning value is Zero which is wrong.
May I know what is wrong with SUMPRODUCT...
Dear Bosco & AliGW,
Received with thanks, Ms AliGW can you please elaborate the following sentence with the formula.
"The ranges in the SUMIFS need to be the same size as each other and only one column in width."
Dear All,
With reference to the attached sample file, I applied SUMIFS formula, but I am getting the wrong answer “#Value!
May I know what is wrong with SUMIFS formula?
Dear,
Received with thanks, with reference to the above, please find the photo shoot of Visual Basic command. May I know where I can put the “Sheet1”?
Thanks.
Dear All,
With reference to the attach a sample file, I have a micro button at Sheet2 to get the direct print by a single click which I am not getting. However, I am getting the print on active sheet1.
May I know what is wrong with a Sheet2 micro button?
Hi,
So far I have a button to start the macro in excel, but that's really uncomfortable.
Basically, I would like to double click a cell/icon to run the macros.
Has anyone any Idea?
Dear Narayank,
Actually, what I want it will be cleared with the attach a sample file, is there any formula to get the sum of the only negative value of the total rows as I got the answer in cell “B20” by manual calculation.
Thanking you.
Dear All,
With reference to the attach a sample file, is there any formula to get the sum of the only negative value of the total rows as I got the answer in cell “B20” by manual calculation.
Thanking you.
Dear All,
With reference to the attached sample file, when I apply the following formula in cell “B20” that is not working to avoid the duplication of negative value in the “Total Housing”.
May I know what should I do to get the correct input?