Search results

Apologies for the rush .

@Marc L request you kindly look into my post/query.

Hi Team, I am looking for some ideas/dynamic formula, to make my comments dynamic based on the sales results from each region. attached is an example.

Hi Vletm, thank you for the question which actually led to resolve my query, i replaced Body1 & body2 to only Body which worked . Thanks.

Hi Team below is the code i have in an excel template to replace text on body of the mail with some values. However while i run code only two texts are getting replaced can you please help. >>> use code - tags <<< Sub DistributeReports() If MsgBox("Please confirm if the default signature for...

Hi Team, I am looking for formula to calculate the cost that should charged for holding the package. Below is the example . for 0-5days no charge $0 charge from 6thday to till 10th day it will $2 per day , so if its 7 days it would be 2days * $2 = $4 and for 10 days it would be $10 the catch...

I would not be able to do that , I can apply and update formula based on what I get response in this forum to my actual data

Hi there, I am looking for a formula or a vba code that code identify the offset line in a huge data set. Below is a sample. Thank you .

Thank you That worked perfect. :)

Hi Team, I am looking for a way were we can make the Index dynamic , i mean based on the date in the attached file in the Sheet1 on Cell C5 the Index should change to respective column in Sheet2 . For Example if date in Sheet1 Cell C5 is 3/13/2020 then the Index formula should be changed to...

Thank you G that's exactly is my requirement , however i was able to find a way and now stuck with another situation. I would need formula to get the count of unique text value with criteria. for example Below have the list from which I need unique count of text which has status as "Yes" in...

Hi Team, I have the 6 products listed and their status in next column , what i looking for is that if the product X status is found as 1 then i need the result to marking as 1 against all the rows where X is listed even though the status of the same against that specific row is not equal to...

Thank you this is very helpfull.

Hi Team, Need help with a macro to lock cells based on the criteria of column header, for example in the attached file , i need all cells locked with column header "Texas" i.e, from column D,H,L,P,T,X from Row 7 to 32. Thanks for your help.

Hi p45cal , Thank you for the above code , However while I am adding couple more fields which i have added in the attached file. Can you help me in edit the code to chose the fields in Rows and in Datafeild . I have attached a sample pivot in Sheet 1 T5 which is the lay out i am referring...

Hi Team , I am looking for help , in creating a code which will need to create the Pivots in different tabs from the Given data in Sheet1 based on the Month. Appreciate you help in this regard. Raghava.

Hi Marc L , I would appreciate if you can share the thread link.

Hi Team, I need a vba code that will fetch the time from internet and save in excel file . i need this to compare the system time with the time from internet. I am looking IST time Regards Raghava.

Hi Team I need vba code that will have to fetch the value from a closed workbook which is saved in the network drive. The problem i am facing the that the network was mapped to letter "X", but the same is mapped to different letter. my network path is \\USXXXNN07\US-PATH while using...

Hi Team, I am looking for sample vba code which will provide me the value of Column B, while the text in column A matches with specific text which searching through ARRAY. Currently below is the code i am using , if the edit can be made to the same that would great. once the Find text is...

Hello, I was wondering if there is a way to run a macro whenever any workbook is opened? I know how to code a regular workbook_open event. Specifically, what I'm after is whenever a workbook is opened, to have VBA evaluate if workbook contains a specific sheet and specific value in that sheet in...

Hi there, What is the best way to trigger a excel macro which will have to run when any excel workbook is open ,even when already an excel workbook is open on the window.

Hi Team, I don't see any response, is there any information or details missing to help with the request. Regards Raghava.

Hi Marc L , As i mentioned i want that addin to check in all work book that user open and works on for those two Specific sheet name and specific text in specfic cell then pop up a message box. if the Sheets names doen't match exit code . Hopefully i answered your question.

Hi Team, Please let me know how can we highlight the specific text only in User form Text box Text in Bold. Ex Text in Text box is " you ticket number is "123456", for further assistance contact Admin with Ticket Number". I need only the text in bold. 123456 and Contact admin with ticket...