Search results

Hi Smallman, sorry for the inconvenience data. In that attached excel, need to delete the Group data and after the group data. I cannot upload my example excel in this conversation. then only i attached to first thread request. Thanks for your reply. Regards, Sampath.S

Hi Khalid NGO. Here i have attached the example of input and needed output excel, which is available in first request thread. I hope this is exact data. Thanks for your reply. Thank with regards, Sampath.S

Hi Smallman, Thanks for your reply. This kind of data only repeated in column vise. approximately upto FZ column having this kind of data only. I need to delete the particular data (GROUP**) and after cells from that GROUP cell in every column. I hope this is enough information. Thanks for...

Hello, I have huge data and i need to delete the particular data from that huge data. For example, A1, B1, C1...etc cell consist some data's. and every cell having "GROUP****" data's. I need to delete this data automatically. Kindly help me for the same. I have attached the example sheet...

Hello, I have one pdf (500 pages) which contain alphanumeric & numeric and image. It is very confidential data. I need to convert these pdf data to excel format. For example, copy one pdf sheet and paste in A1 cell in excel. same for other pdf pages also. Could confirm any portable software...

Thanks for your help. It's working fine. but put more effort for large datas. Thanks for your assistance.

Hello Narain, Your mentioned point is right. I need only extract the VS3041 and after data's. Needed out examples are available in Output sheet in attached one. Kindly assist me. Thanks for your reply. Regards, Sampath.S

Hello, I have attached the example of document. In first sheet we have lot of data's and I need to extract the particular data(VS3041*** etc) and these extracted data's to be saved in next sheet as i attached examples. Kindly assist me for this which is very helpful for my process...

Hello, I have a pdf in no's of pages. which has alphanumeric data's and images. I need to transfer the alphanumeric data only from pdf to excel in page based. first page transferred to first column, second one is second column....etc. kindly suggest me any macros. Regards. Sampath.s

Hello, I have list of data in sheet1. and i need to extract the particular data from that list. i have attached one example for my request. kindly assist me any macros or functions. regards. sampath.s

Hello, I have list of data and i need to consolidate the particular data from that list. Could you help me if any macros or formula. I have given the samples below. Input is 132 RN1215-MN- RN1215-SE- 55-RN 158 Output RN1215-MN-55-RN RN1215-SE-158...

Hello, I want to extract the particular data from huge data. here, I have attached the example file for better understanding. thanks sampath.S

Hello, I have a list of alphanumeric values in excel. and i need to extract the particular data from that list. Example: Input 222-756-1986-2022-SE3034-MA-RA 104-107-201-222-SE3034-H4B444-ASPRSECT-QUCESTS 999-MAN-RAS-PQR-AVA-2478-SE3034-ASPREISEI-MA-RA Needed output 222-756-1986-2022...

Hello, For my project simplification, I have a PDF, which has lot's of pages, every pages contain one image and lot's of text (like numbers and alphabets). if i manually convert the pdf to excel. i copy that pdf sheet and paste into excel column cell. ( numbers and alphabets only paste into...

Hello, In my project, I have a pdf, which has lot's of pages, every pages has huge numbers. I need to convert the every page pdf data to excel sheet in column based. Is there any software available, please assist me. Note: already we check with online, but i am not satisfied. kindly...

Dear misra, only Q25 has drop down list. And when i entering the MRCS in A1 cell, B1 cell will show that drop down list. that drop down list contain "NEW" and "MOD". Please assist for this to my dashboard. Best regards, Sampath.S

Hello Luke, Thanks for your reply, but when i entering others in A1 cell, that drop down list is not shown in B1 cell. Kindly assist me for my dashboard. Best regards, Sampath.S

Hello Dude, I have drop down list in one cell(Example - Q24). If when i going to add if statement in B1 cell i need to show that drop down list. For Example. Q25 has drop down list Q24 has "NEW" If A1= "RT" then B1 should show NEW. If A1= "MRCS" then B1 should show drop down list. If A1=...

Hello SirJB 7, Thanks for your reply, but how can i find the "SE" in this script. when i copy this script and paste to the macro area. It shows error. Please give any suggestion for the same. Best regards, Sampath.S

Hello, I have huge data like alphanumaric. I need to extract the particular data from that huge data. example data are mentioned here. Input. A B C D 121...

Hello Kanti, Thanks for your prompt reply, I have confidential pdf data it could not share to goole. kindly help me for the same. Warm regards, Sampath.S

Hello, I have 200 sheets of pdf file and need to convert that pdf file to excel(.xls) in single shot. every pdf sheet data transfer to every column in excel. please help me for this. I do not have any specific software for that. I can not use in my office if available. Warm Regards, Sampath.S

Dear Debraj, We cannot installed that converter to our system due to office administration restriction and that project pdf is very confidential. So could you help me for any macros or VBA scripts for the same. Thank with regards, Sampath.S

Hello Sir, Need to transfer all the numerical, alphapet and alphanumaric data's from pdf sheets to excel. I have one pdf package, which has 300 sheets. I need to transfer that pdf data to excel sheets. Note : Every pdf sheet data to be come to every excel column. Please help me it is very...

Dear Faseeh, My input (Sheet1). Column A Column B Column C Column D Row 1 RT5005 - R - RM-BVR1(this is in column A1) Row 2 Row 3 RT5005 - R - RM-BVR2(This is in Column C3) Row 4 Row 5...