Search results

Hi Khalid NGO, In Previous thread, Mergeme code is working fine but every time have to change the sheet no when that workbook have huge data. and test code is not working which was shown like "runtime error" and subscript out of range" message. Kindly solve my request. Regards, Sampath.S

Hi Nebu, Thanks for your reply, My request is sheet1 has input data and sheet2 is output data. I have huge input like sheet1 and my request is extract the "SE*" from input as output sheet. Kindly provide the solution for the same.

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

Hi Marc L, Thanks for your reply, This code is not working to my expectation. In the sample attachment, first sheet is input and Output sheet is having only after data of "SE**** - R - ". Please give excel code for getting output as attachment. Thank with regards, Sampath.S

consolidate en number of sheets in single sheet

Hi Marc L. That first thread for different output( Delete particular data) Second one is for another output ( Extract particular data) Need two output for my job. Kindly consider my request. Regards, Sampath.S

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

Hi Hui, Thanks for your reply, In Presentation1.xlsm, Column E & I does not delete the "SE" and before data of SE only deleted when ran this macro. I need to delete only SE and after cells of SE. kindly provide the solution. Thanks and regareds, 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

yes. It's necessary for above request and need one more condition for this macro. Need to delete "N°" and remove second row in order wise. Thanks with regards, Sampath.S

Hi Khalid NGO, My request is macro for searching "*SE" for the range A1 - NZ200 and highlighted by any color in cells. Kindly consider my request. Regards, Sampath.S

Hi Khalid NGO, Thanks for your reply, I have lot of files as example file, and "SE" character only standard for all the files, I need to identify the cell, which has any character before "SE". please consider my point. 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

Hi Nebu, When using your given option. same message will appear after save that file. Note: In this workbook, Using 3 macro. 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

Hi Khalid NGO, Now It's working fine. thanks for your support. Regards, Sampath.S

Hi Khalid NGO, I customized that macro for my requirement. but which is not working. Could you help me for the same. Herewith, I have attached the samples for the same. Regards, Sampath.S

Hello Asheesh, I have attached the screen shot for sample. 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

Hello Ashessh, Thanks for your reply. Once using that CTRL + H, that particular Cell only replaced. but I need to remove "GROUP - *" text and after cells from GROUP contained cells. please check the sample file. Regards, Sampath.S