Search results

No i am not understanding you, please see the attached sheet there is row number 2 where data is in horizontally format. every word has some number like in the beginning "bell" has 10 ...etc. so now i want to count the "Stock" in row number 2 which is ">=5". result should be 1. whenever i am...

I think you have not opened the attached sheet it doesn't work please look in to. Regards Nipendra

How to count with in the single row horizontally how to count the Stock word which is >=5 Please find the attached sheet here. Nipendra

thank you sir

Hi all, i have little query here, I am working on the 200 pages document in word 2010, and i need a hyperlink on a every page to go back to the home page(Fisrt page), let say i am on the page number 32 and want to go back the first page it is difficult to go back. I have one way that I can make...

the code which you have provided it is working fine. now i am trying to do it by excel formula like in the attached file if the dropdown is not empty then it should show the start time else it should be empty. however it is working fine but when i am trying to drag the formula below and going to...

Yes thanks it is superb but is it possible by the formula also, because whenever i am trying with Now() function and going to the next value to select it is updating the last time also. i am trying with "=IF(C2="","",NOW()-TODAY())". any idea Nipendra

Hi all here i have attached a sheet where i am trying to put some vba automation but i am confused. i need to insert the current time when i select the value from drop down in the column "C" i am confuse about the event, what type of event should i use for this. any idea please suggest...

Thanks a lot next time i will do it my self Regards Nipendra

here i have attached the sample

Hi all, I am trying to make an automation where I have the database in “sheet2”, in database I have two company name like “A” and “B”. I want to split the Company “A” data and Company “B” data in to different sheets. I have inserted combobox in “sheet1” where I am using the company name I want...

Thanks a lot buddy you are Rock I got the solution

As of now I am able to find the record only in a particular column if I want to make it dynamic means over all the sheet then I think I need to use usedrange but how can you please suggest something Regards Nipendra

i have tried it its working great but I need to pick all the column values in listbox currently it is showing only the the column where i am searching i have 8 column a,b,c,d,e,f,g,h.

that's look perfect dear but i want to call the entire row in listbox

thats super perfect dear but i want to add all the searched data in to below listbox which is i defined on the user form.. how will it done.. my code is.. ListBox1.RowSource = range(copyrng).Address but getting some error "method range object failed" Please help

Thanks Debraj, but it doesn’t work for when you are using lower case word instead of upper case. Regards Nipendra

Hi experts, let suppose i have a database in excel sheet1 and a userform with in the same spreadsheet, i have to update database every day now it’s a very heavy amount of data. the challenge is i am getting whenever i am going to enter some new values it gets duplicate some time because of...

thanks Experts probably got solution closed now

hi all i am facing an error here with this calendar i want to use this calendar in my existing project. please tell me what does the mean of library missing error.

Hi experts, Sorry if this sounds looks dumb Is it possible to track system time by vba code in Excel while system is active. I need to know, if I want to build an application in excel vba on the below requirement-: 1)-whenever i'll login vba code should take as start time 2)- when I'll take...

I have done it dear thanks for your input and reply I will share it later on

Dear Lohith, glad to see your reply and appreciate your efforts but my requirement is little bit different may be it is perfect understandable in above post please help me out if you can. Regards Nipendra

Lohith i am almost in...the final, but facing an error what I am doing to get it.. Dim rng As Range "creating a variable as range type" Sheets("data").Shapes(1).Copy...

thanks for your valuable reply.... I am working on a excel vba project where I am creating a word document. now I need to insert a logo for the same document, and this logo is already saved in my one of excel sheets. for more clarification I am attaching here a example file.. let me know...