Search results

I got your point. Thank You sir.:)

Dear Experts, I want to highlight the entire row instead of single cell using conditional formatting and datedif formula. Kindly help on it. Thanks & Regards Bipin

Thanks Ninja

Dear Experts, PFA enclosed herewith. Is there any formula to get desired result? It's cumbersome process to sum each voucher manually.

@bosco_yip Sir, You're a genius person. Thanks a ton sir!:)

Dear Experts, PFA enclosed herewith. Kindly suggest the appropriate formula.

@pecoflyer Yes sir. I saw your answer and I appreciate that. But it was not suitable in my condition as it required me to create pivot table.

Perfect formula! Thank you so much @bosco_yip

Thank you for your reply but I didn't get the result I wanted. I want sum of column "D" in such a way that it sums only those values which are unique based on column "A" and criteria "C" from column "C" Result expected in cell D3=700 (500+200) I hope I explained it properly.

Hello Experts, PFA How To Sum (Column "D") Based On two conditions i.e. Unique Values (Column "A") And Criteria "C" in (Column "C")? Unique Values Of Column "A" Are Not Known. It May Be Anything i.e. Text, Number Etc. Thanks Bipin

It's not working. It says 'syntax error' marking second line red.

Sub test() ' open IE, navigate to the desired page and loop until fully loaded Set IE = CreateObject("InternetExplorer.Application") my_url = "https://services.gst.gov.in/services/login" With IE .Visible = True .Navigate my_url .Top = 50 .Left = 530...

I mentioned the site name in the file. Somehow I got success in auto filling 'Username' and 'password' but now it says 'please enter the mandatory field. PFA file.

Thanks for your reply but it's not working for me.

Dear Experts, PFA file. I want to fill up login credentials automatically using VBA. I am unable to proceed after login page. Please suggest suitable edit. Thanks

Yes

How can I get web page code?

Dear Experts, I'm looking for a VBA which can automatically fill username and password on any particular website. Can anyone please give me such VBA or link if any to of such VBA?

Thank you so much sir.:)

GraH - Guido Sir, PFA enclosed herewith. I require Separate Column for each field. Party name address Product name Quantity Amount

Thank you experts for your interest in my query. But can I get the value against the name of the product? PFA format of file.

I have a data arranged in the manner mentioned below. Main Category Row 1 Sub Category Row 2 Name of the product Row 3 ..... and so on While Main category does not change, sub category and name of the product keep on changing. So I want to arrange the data in such a way...

Dear Mr. Lobao, If you read the body, it clearly states "name". Nowhere I mentioned "number". But anyway I am thankful you for taking interest in my query. Thank You.

Thank you so much Sir.

No, I want the names of the absent students.