Search results

Hi Narayan, The code is now working perfectly. Thanks a lot for your help. Thanks & Regards, Anupam Tiwari

Hi All, I have come up with the below formula that can give us the coun of number of used rows in a worksheet without opening the file: =MAX(ROW('Z:\Anupam\Desktop\[Excel_Test.xlsx]Sheet25'!$A$1:$Z$65530)*('Z:\Anupam\Desktop\[Excel_Test.xlsx]Sheet25'!$A$1:$Z$65530<>"")) But the issue is we...

Hi Simon, Welcome to Chandoo.org Forum, Please enter the below formula in Cell J1 and drag it down till the last row of your data. =IF($D1="Y",$E1&$F1&$G1&$H1,IF($D1="N",0)) Please let me know if you find problem in the above formula. Thanks & Regards, Anupam

Hi Somnath, Set NewSheet = Sheets.Add(Type:=xlWorksheet) In the above line, NewSheet is an object type variable in which new sheet object is being stored using Sheets.Add as Sheets.Add insert the new sheet in the workbook. Whenever we declare any variable as an object type variable, we use...

Hi Narayan, You above provided code is really very nice however executing it step by step and keeping "Main" sheet hidden, I found a little issue mentioned below: If the "Main" sheet is hidden that time the code is not working in the desired manner. When the "Main" sheet is hidden and...

Hi tazz, I don't know if I have correctly understood your problem however as per my understanding please try the below steps: 1. Right Click on spreadsheet(Main) and click on Move or Copy... 2. On dialog box appear where you need to select spreadsheet(Main) in Before Sheet: list. 3...

This forum is the best forum and the migration gave us the improved plateform to share our thoughts or ideas, to get familiar with other members. All this is like Icing on the cake. Thanks to Chandoo and All for giving us this wonderful Forum.

Hi Narayak991, I always wait for your reply to any of the question asked on the forum. Your reply is always very unique and descriptive to understand it well. Your explainantion is awesome.

Hi sreekhosh, You can browse the below link which can help you. http://www.xtremevbtalk.com/showthread.php?t=179120 Thanks & Regards, Anupam Tiwari

Hi mr_hiboy, Try the below code Sub DeleteColumns() lc = Worksheets(&#34;Sheet1&#34;).Range(&#34;1:1&#34;).End(xlToRight).Column For i = lc To 1 Step -1 If Cells(7, i).Text &#60;&#62; &#34;Yes&#34; And Cells(7, i).Text &#60;&#62; &#34;yes&#34; Then Columns(i).EntireColumn.Delete End If Next...

Hi mr_hiboy, Try the below code, this can help you to fullfil your requirement. Sub DeleteColumns() lc = Worksheets(&#34;Sheet1&#34;).Range(&#34;1:1&#34;).End(xlToRight).Column For i = lc To 1 Step -1 If Cells(7, i).Text &#60;&#62; &#34;Yes&#34; Then Columns(i).EntireColumn.Delete End If Next...

Hi shrivallabha Thanks a lot for your help. Your code is working fine for me. Really appreciate your help. Thanks & Regards, Anupam Tiwari

Hi shrivallabha Thanks a lot for your help. I have gone through the above link and learnt new things which are usefull for me however still I could not find anything to close opened folder. I am also putting my efforts to find the solution and also looking forward to get the solution from...

Hi All Excel Ninja & Experts, I need your help to know the VBA code to close specific opened folder seen in taskbar. I have searched a lot but could not find exact code which can help me to loop through all the opened folders in taskbar and then can close specific folder window like we do to...

Hi Hui, Congratulations!! I have learnt a lot from you and always ready to learn more. Thanks & Regards, Anupam Tiwari

Hi acpt22, I have corrected my above provided formula as erlier one was giving me error at one point. Below formula is now ok...

Hi acpt22, The above formula will give you sum of top 3 records as per the condition however if records matching to the condition are less than 3 that time it will give you sum of those records and if there is no record matching the conditon it will give result "No match found". Thanks &...

Hi acpt22, Welcome to Chandoo.Org. Please try below formula and let me know if its working fine for you. 1. Considering your data in column A, B and C having header. Write Low, High and Medium in cell F1, G1 and H1 respectively. 2. Write ME, CE and WE in cell E2, E3 and E4 respectively...

Hi DaveTurton, Is all your names are in column A and Time is in column B, if yes please do as below: You have defined all the data under the header row 'Week5_data' however I think you need to modify the data range in the defined name. Press Alt+IND to open the Name Manager and select the...

Hi GGGGG, You can try using short cut key ALT + ; to copy only visible cells. 1. Select the range to be copied. 2. Press ALT + ; and then press CTRL + C to copy 3. Paste the selected range to the desired sheet or column. It works fine. Thanks & Regards, Anupam Tiwari

Hi aneeshao, Welcome to Chandoo.Org Please go through the below link that may give you an idea how to hide the cell value using conditional formating. http://chandoo.org/wp/2009/06/05/hide-cell/ Thanks & Regards, Anupam Tiwari

Hi Shivani, You are welcome. Thanks & Regards, Anupam Tiwari

Hi Shivani, Welcome to Chandoo.Org. Please try below formula that you can copy to different sheets as per your need. =LOOKUP(B12,{0,10,11,15,16,20,21,30},INDIRECT("Sheet4!C2:J2")) Here I have put the remarks in Sheet4, from C2 to J2 You need to change sheet name and range as per your...

Hi, I have tweaked my previously mentioned formula as below and this is working fine with no error however will go with Kavin's lookup formula which is very nice one. Considering that the value BLR5658DTDC is in cell A1...

@Kevin, Very nice formula. Just devoting my time to understand your formula. Thanks & Regards, Anupam