Recent content by nadjalil

Thanks AJ but unfortunately i have only 2010 version in my office and this cant work there. do you have anything else which can work with older version of excel... thanks for your hlep. Kind Regards

Good Day to all of you I have a file for stock control where i need to see when last time we sell a product. i need a formula in column U which bring the header value in it if that column has got a number value. Column G is Item Ref. Column H is Item Description Column I to T are the columns...

Dear All i have a payment template where i need to instruct my bank to make payment in different currencies and i have to put amount in numbers and words. i want when i put amount in number it convert into text automatically, we are using this formula to convert number into words...

Dear Nebu thanks for the file i hope i can start working with Pivot as i didn't work before could you please give me an insight of who you did the table on consolidated sheet. i hope you may double click on something in pivot and it must have extracted it on new file, can you tell where you did...

Hi check the attached file if this VBA Script is working for you. what you need to do, Select the column where you want to remove the empty cells and run this macro it'll delete the entire row which has an empty cell on selected column... i hope it'll work...

Dear Nebu thanks for looking into my request, my format of the report will remain the same as i have on BU 16 Sheet Customer Code in "A", Customer Name "B" Brand Names in "D" and then Jan - Dec for Budget, Jan - Dec for Year 2014 and then Jan - Dec for Year 2015 but i need to display all those...

Dear Nebu it's going to be 30000 rows for actual 2014 and 15 and around 500 row for Bu 2016... thanks for your help.

Dear All i have a file where i have 3 databases Actual sales for 2014, 2015 and BU 2016, they are not similar but in all three customer name and brand names are same and based on these two elements of my database i have to make a unique list. i need a formula which can bring customer on a new...

thanks Nebu for your time i got you both correctly and it's working fine in file...

Thanks Boss you understood my file and requirement correctily.... thanks for the inputs

Hi Nebu my actual file has 1000 row index numbers and if i can divert it through a cell where i can give cell no i can save a lot of time to change almost 2000 formulas. i dont mind if you can give some thing simpler... thanks for your help

Dear All i have a problem to bring row index number from a different cell by indirect formula in Hlookup. attached is an example of my file... thanks to help me on this... Kind Regards

Dear Narayan Sir thank you very much for your help, it's really working fine but could you be so kind to explain me what exactly you have done in my file, i just notice that you made some changed to my sheet List and you put only =INDIRECT() in Data file with the cell reference. but other than...

Good morning all i have to validated data based on Month selected in Column A of a sheet "DATA" in Column B and conditional range is on Sheet List so, if A1 is January B1 should display only dates belongs to January if its March than Dates only for March and so on i did validate this upto July...

thanks Marc could you please let me know if i need to add more filler let say based on few more criteria e.g. Name, School etc how i can amend the same code. thanks again for your help