Search results

@Narayan: Can you please upload the file? Raja

Hello Narayan: Tried the above code but unfortunately didnt get the desired result. Could you please let me know if I'm missing out on something? Thanks, Raja

@Narayan: Just noticed your last post. Let me check if your code does the trick for me Thank you so much for your time and support Raja

@bobhc: Thanks for your comment, would definetly browse the link shared by you. @Narayan: As you rightly said, I do get the correct dropdown but I want the dropdown list to open up on its own without clicking on the box appearing at the extreme right of the cell. I doubt my word "EXPANSION"...

Hello Friends, I have a sheet with 2 dropdown lists updated in the cells E10 & G10. E10 has the list of the managers and G10 has the list of engineers associated with the respective manager. Is there are an option where the dropdown list of cell G10 expands (same as you click on the pointer...

@SP: Very impressive Raja

Hello Nitin, You can achieve the desired format by adapting a pivot table. Please check the attached file, hope this serves your need https://www.dropbox.com/s/f9m0g5vl8znu7em/Sales%20Data.xls?m Raja

@Faseeh: Neat & Simple answer. Appreciate bro. Regards, Raja

@SP: Thank you so much. I have applied to my sheet and found it working as I desired. Am in process of applying this code to a couple of my reports and I might get back to you in case if something blocks my task Thanks bro Raja

Many Thanks, Deb I tried stopping the code but failed and suddenly all my open excel files got closed. My hardwork put on a report had gone waste since I didnt save. Need to start again from scratch :( Raja

Hello Narayan, Point noted, Thank you. Regards, Raja

@SP: Sub KeepDoingSomething() Dim i As Integer i = 0 Do Until i = 10 [A1] = i + 1 Debug.Print i Loop End Sub

Team, Is there a way to stop a running VBA code? Have a code which loops based on a condition and the condition has gone wrong and inturn executing the code to run for ever. Any quick thoughts? Raja

@Kaushik: Thanks a lot for the code but as said this code comes with a limitation, I need to wait still you come with something which does exactly what I am looking for. @Deb: Manys thanks for your effort and time. As said before the data in the sheet is very inconsistent and has multiple...

@Kaushik: I'm with an assumption that even if I follow your first pointer still the end user would be able to see the formular bar and formulae as well because unchecking the formula bar option at my end will be ineffective to the other users. Please correct me if I'm wrong Raja

@sgmpatnaik: My file has a set of tables which has the formula =REPT("|",E3/"00:05:00") to a range of cells. Now the problem is the data in the table is inconsistent and often tends to change and this makes me to have the sheet unprotected So shared this query here to know if I can hide...

Thanks for the input, Hui Bit disappointed to know that even excel has limitations :( Raja

Friends, Is there an option to have formulaes "invisible" without protecting the sheet? Thanks & Regards, Raja

My apologies for the wrong post @Hui, Thanks for this correction Raja

@parvez: Can you please clarify the below: Column K has Amount and Column L has Cost, now what does this "COST" refer it. -->Is it the actual cost to the company? -->Does (Amount - Cost) give the "Profit/Income" value? Raja

@MrBramme: You gave a shot which was pretty close, thanks for that @Luke: Many thanks, you got that absolutely perfect Raja

Need small help in getting a desired format through VBA script: My code takes a value from a cell which is in date format and it gives the output in "1/8/2013" format.Below is the code: "Your reporting day would be on" & "" & "" & Sheet1.Range("G" & (Cntr)).Value and the output for this is...

Luke & Kaushik, Thank you so much Regards, Raja

@rahulsharma, you need to just unprotect the sheet (there is no password set) Next UNHIDE the source sheet Also, please refer to the "Name Manager" in the formula tab. Hope this will make you understand how the dashboard works. Regards, Raja

@ Narayan Can you please describe the funtionality of -- in the formuale shared by you? Regards, Raja