Search results

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, 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, 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, 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...

Hello, I have a tracking sheet for our production. Following requirement mentioned for this needed excel. If A1<="10" then B1 is "C4" If A1<="50" and >"10" then B1 is "C3" If A1<="65" and >"50" then B1 is "C2" If A1<="120" and >"65" then...

Hello, I have to create tracking sheet for employee production, For that, can't create the above 32 condition of IF statement. I known only Limited conditional if statement. Kindly suggest me for this. Regards, Sampath.S

Hello, I have create the employee tracking sheet. In this sheet, I need following requirement for this dashboard. 1. If put category item in A1 cell and put Complexity item in B1 cell, C1 need formula for respective number. Note : that category, Complexity and numbers are mentioned in...

Hello, I have an production tracking dashboard, In that dashboard, When i entered C1 in A1 cell automatically B1 will reflect 5 if C2 in A1 cell, B1 get 6 if C3 in A1 cell, B1 get 8 if C4 in A1 cell, B1 get 10. I am using below mentioned formula but can't get the output in B1 cell...

Hello, my request is when enter the character in a cell, which will automatically change in uppercase. could you help me for this request. Regards, Sampath.S

Hello, I have No. of sheets in excel workbook. and need to combine all sheets into one sheet in same workbook. Am using below code to combine all sheets. but the result is all the sheets are combined single column in master sheet. Need to combine every sheet data into ever column of master...

Hello, I have number of sheets in excel work book. and need to consolidate all the sheets into single sheet in same workbook(last sheet). here I have using below mentioned code. but some time, No of sheets can be varied. Sub MergeMe() Dim i As Integer For i = 1 To Worksheets.Count - 1...

Hello, I need to extract the particular data after SE**** - R from huge data. and After SE cell data also added in extracted data (output). Herewith, I have attached the example for that. Kindly solve this. Regards, Sampath.S

Hello, I have use macro 3 macro's in excel sheet. after run two macros, i need to replace some data in that sheet, when use this replace command, got some error. Please solve this issues . Regards, Sampath.S

Hello, Need to identify the particular data cell from huge data. here i have attached the example file. In that example, marked cell only need identify. Kindly help me for the same. Regards, Sampath.S

Hello, I have huge data in excel and i need to delete the particular data from that. Already got the excel script for deleting that "SE" from huge data. when i run that script, all the data was deleted in SE contained cell. Need to modify script from my below request. Sub RemoveDataAfterGrp()...

Hello, I have protect the VB script using password but unfortunately i forgot that password. could you help me to open that VB script code screen or remove that password. regards, Sampath.S

Hello, I have 3 macros using in excel workbook. I need to assign one shortcut key for run all macro's. Could you help me for that. Regards, Sampath.S

Hello, I have huge data in excel and need to delete the particular data (N°) and 2nd column (totally) from that. Already i recorded macro and use replace command for that. but need to do this things in sheet3 only. could you provide any macro for that. Thank with regards, Sampath.S

Hello, Can not save macro excel. While saving that excel, warning message will appear. That warning message screen shot was attached here. Regards, Sampath.S

Hello, Once put formula in particular cell, Which is shown like "#VALUE!, when source cell is empty. how is possible to avoid this. Kindly help for the same. Thank with regards, Sampath.S

Hi, I have an huge data in column wise, Every column has "GROUP - *" . Request is 1. Delete the particular data (GROUP - *). 2. * means more data may come after GROUP - . Herewith, I have attached the samples. Kindly assist me for the same. Thank with regards, Sampath.S

Hello, I have en number of sheets in excel workbook. I need to merge all the sheets into single worksheet. Herewith, I have attached the example file.kindly help me for the same. Thanks with regards, Sampath.S