• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. anupamtiwari05

    Inserting identical spreadsheet ?

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

    how-to-count-the-number-of-rows-without-opening-an-excel-file

    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...
  3. anupamtiwari05

    IF FUNCTION HELP

    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
  4. anupamtiwari05

    asking explanation about vba code

    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...
  5. anupamtiwari05

    Inserting identical spreadsheet ?

    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...
  6. anupamtiwari05

    Inserting identical spreadsheet ?

    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...
  7. anupamtiwari05

    New Forum Celebration

    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.
  8. anupamtiwari05

    Hi Narayak991, I always wait for your reply to any of the question asked on the forum. Your...

    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.
  9. anupamtiwari05

    How to Turn Off “File Now Available for Editing [SOLVED]

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

    VB to delete columns with value in specifc cell [SOLVED]

    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...
  11. anupamtiwari05

    VB to delete columns with value in specifc cell [SOLVED]

    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...
  12. anupamtiwari05

    Need VBA code to close specific opened folder seen in taskbar. [SOLVED]

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

    Need VBA code to close specific opened folder seen in taskbar. [SOLVED]

    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...
  14. anupamtiwari05

    Need VBA code to close specific opened folder seen in taskbar. [SOLVED]

    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...
  15. anupamtiwari05

    Congratulations Hui 5,000 Posts

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

    Sum of top 3 records based on filtered criteria

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

    Sum of top 3 records based on filtered criteria

    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 &...
  18. anupamtiwari05

    Sum of top 3 records based on filtered criteria

    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...
  19. anupamtiwari05

    Most common string in named range

    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...
  20. anupamtiwari05

    Blank rows

    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
  21. anupamtiwari05

    Formula Hiding

    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
  22. anupamtiwari05

    How to use LOOKUP Formula for returning values stored in another Worksheet

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

    How to use LOOKUP Formula for returning values stored in another Worksheet

    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...
  24. anupamtiwari05

    HOW TO SEPARATE TEXT AND NUMBERS ?

    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...
  25. anupamtiwari05

    HOW TO SEPARATE TEXT AND NUMBERS ?

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