Recent content by sampath

Hello Chihiro, I have attached my sample excel file for filtering option. In this excel, Range C4 has input dates and need to filter the output in H6 and same time no. of months should be displayed in H6. Kindly provide the suggestion as my requirement. Regards, Sampath.S

Hello Chihiro, Thanks for your reply, Here when using filter / drop down list, which is shown all dates in the list, but I need to filter based on month and year. Please suggest how to filter as my requirement. Regards, Sampath.S

Hello, Actual In my excel ( sheet1), range A1:A100 having date's in dd-Month-YYYY. Requirment In same workbook (Sheet2), Need formula in B6 to filter the Actual range(Sheet1!A1:A100) in Month and year based. Please clarify the same. Regards, Sampath.S

Hello, Actual Data In my excel ( Sheet1 ), Range A1 to A1000 having different date's from 1-Apr-2011 to 25-Apr-2015. Required data In same workbook ( Sheet2 ), Range B5 need how many of cells having after 1-Apr-2015 in Sheet 1(Total cells). Please clarify the above requirement. Regards...

Hello, For project assignment, I need VB macro for extract the data's from data list, which was available in sheet 1. Particular data count only extracted and placed in sheet 2 based on filtering condition. Note: Sheet 2 had fruit name and company code already, Need only count based on...

Hello Nebu, I need macro coding for that, because i attached that code into another macro. Kindly provide the VB coding for that. Regards, Sampath

Hello, I have ennumber of data, which data file was attached here. In that file, I need to change the data properties based on condition. Required Coding. If there is no data in cell(empty), that cell was changed in blue color. If any cell having 7 and above, that cell was changed in red...

Hello, There is no coding in given attached file. could you provide the coding for that output. Regards, Sampath.S

Hello Chirayu, Thanks for your given coding, I have one more requirement for the same excel, I have enclosed this sample excel with this mail. Here, I need to filtering optioned based on company coding and quantity. Output will be shown in output sheet. Kindly provide the macro code for...

Hello, I have huge data's in sheet 1. Need to filter from huge data and delete the duplicate data's. Kindly provide the macro for that. Herewith I have enclosed the sample here. Regards, Sampath.S

Hello Deepak, What link to checking.....Pls. Regards, Sampath.S

Hello Deepak, Need macro coding for open MS Word (open application and not for particular word file)and close it after 15 seconds. Please provide the coding. Regards, Sampath.S

Hello, Need to open any MS application / PDF using macro coding. Please share the coding. Regards, Sampath.S

I have a very long if condition for my dashboard. kindly help me for my requirement which was mentioned below. IF A1="CMO" and B1="S" then C1=12 IF A1="CMO" and B1="M" then C1=20 IF A1="CMO" and B1="C" then C1=40 IF A1="PDB" and B1="S" then C1=12 IF A1="PDB" and B1="M" then C1=24 IF...

Thanks for your support. This is my requirement what I expected. Thanks once again!