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
Hi,
I have a pdf file, which has 200 pages. And every page's has image and Alphanumeric number.
For Normal procedure, copy the pdf page and paste it on excel. that time alphanumeric data only pate it on excel.
Now, Need automatic conversion such kind of procedure. is there any macro's for...
Hello,
Once i put the number 268 or 15789, which is automatically changed like 2.68 or 157.89.
even check the format cell option also. but cannot change this thing. kindly solve this problem.
Regards,
Sampath.S
Hi Yagimli,
When check with your idea, that GROUP character can delete but need to delete the next cell data from GROUP. kindly suggest any function or macro.
Regards,
Sampath.S
Hi,
I have en number of data in excel. Keep the particular data from huge data in every row.
In column A, using "RIGHT" function. Need Output as "G"column from "A"column.
kindly assist me for the same.
Thank with regards,
Sampath.S
Hi Misra,
Thanks for given this Macro. One clarification. some time that "GROUP" criteria will come in naming cell. that time how can we assuming "-".
Could you solve this. Herewith I have attached the same file.
Thank with regards,
Sampath
Hi Misra,
When using this macro. output shows only numbers like A1 has 1, B1 has 2, and C1 has 3. i cannot get the expected output.
Kindly solve this clarification.
Regards,
Sampath.S
Hello All,
I have column wise data in excel sheet and every column has "Group-1*******".
Here I Need to delete this data and after data from "Group-1*******" in every column.
could you give any macros for this. because having more data.
Here with I have attached the samples for the same...
Hi Luke.
Got only alphanumeric in excel, while copy that PDF page (Ctrl+C) and paste it in excel sheet(Ctrl+V). Does not paste graphical image and graphical image code in excel. That kind of process only need in macro for all sheets. if it not possible, please suggest any portable text grabber...
Hello Hui,
In this macro, when using F8 key, "Late Binding.xlsm" macro has so many over falls.could you please correct this macro as previous mail.
Regards,
Sampath.S
Hello HUI,
In this macro, some numbers not detected (not copied to excel ).
For example, If PDF has R335, excel shows only R3 or 35. and sheets also not matched. and i need to consolidate all the sheets in single sheets.
Here with I have attached the PDF and output excel. kindly give solution...
Hi Luke,
Thanks for your reply. I need another type of output. That output type sample has attached here. This is the copy & paste procedure from pdf to excel. Is there any possibility for your macro? Kindly provide for the same.
Note : I have more sheets (upto 300 pages) in this pdf...
Hello Hui.
This is confidential data.can not share in online. could you provide any macros or suggest any portable software(.exe file)
Regards,
Sampath.S
Hi Luke,
I have some clarification about PDF to Excel. Here I posted one pdf and needed output excel. How to implement this pdf in your given macro. could you clarify for the same and i need to convert more pdf pages using this macro.
Regards,
Sampath.S
Hello All,
I need conversion macro from PDF to excel. I have above 200 pages in single PDF package. Manually i can copy that page and paste in excel. but which process will take more time. and such kind of PDF packages need to convert. could anyone give solution for conversion macro...
Hi,
I have an PDF format file and which contained data need to be saved in excel file in different order.
I have attached the example files for the same. Kindly help to make any macros for this conversion.
Thanks.
Sampath.S
Hi,
For my office activity, I have some questions (optional type ) and I need these qustioned have to raised for employee in survey format. And employee answer should autometically placed in common path. Kindly assist me is there any software or for the same.
Regards,
Sampath.S