Search results

Oh that's the point, it copies the whole values for a column if it doesn't get the value it looks for. So it copies the whole value of Column C to Column D if it doesn't get any first parenthesis, so is for Column E. How can i get rid of that and shows the cell Blank if there is no value for a...

In existing worksheets Sir.

I am sorry for being late. I have attached a real nature of data that I am currently working with. Monty's code is good but if you could see the Column E in every sheet, it is not extracting the value of third parenthesis, it is copying the same values of Column C to Column E. Sir JB7, i do...

a) Worksheets: 20 approx b) Rows: 1000 approx c) It extracts data from an ERP software where Warehouse Order information changes very frequently. d) no idea.

Thanks, haven't got that though.

Thanks Monty. You've been really helpful :).

Yeah mate :D

Thanks mate. You've made my life easier. Cheers!

Thats awesome Monty, u rock. One last thing, if somebody clicks on the button twice, it would be a disastrous. It just copies the whole values in Column C twice to other sheets. can that be checked? I am happy enough with the solution though. thanks mate. Cheers!!

There would be thousands of rows and many worksheets full of complicated order information so what i need is to cut the information down to minimum. And it is quite impossible to go through every sheet and edit the order information. i was using this formula but my boss wanted me to get some...

Well I am a novice here and looking for your expert solution. I am attaching the file again if you can open it.

Monty it is just taking off the values inside the parentheses in column C and copying the same to column D and E and unfortunately not changing anything in sheet 2 and sheet 3. All I need is take off the values inside first parenthesis () in column D and third parenthesis [] in column C and...

Thanks Monty, its not working unfortunately. I am posting my code here so that you can quickly look at the problem: Sub test() Dim ws As Worksheet For Each ws In Activeworkbooks.Sheets .Columns(3).Copy Columns("d:e") .Columns(3).Replace "(*)", "", 2 .Columns(3).Replace "", "", 2...

Dear Experts, I have a set of data in three worksheets and the macro i am using should run in three worksheets at a time from a single macro button in Sheet 1. The data that I have needs to be extracted from Column 3 and separate the values in () in Column 4 and the values in [] in column 5...

I would like to share the best answer i'v got to my question is: Sub test() Columns(1).Copy Columns("b:c") Columns(1).Replace "(*)", "", 2 Columns(1).Replace "", "", 2 Columns(2).Replace "*(", "", 2 Columns(2).Replace ")*", "", 2 Columns(3).Replace "*[", "", 2 Columns(3).Replace "]*", "", 2 End Sub

I am sorry I wasn't aware of the cross-posting policy being a newbie in forums. I would follow the rules from now onwards. I joined few forums yesterday to have an answer to a problem. Thanks for correcting me. Peace.

Thank you vletm.

That's my post YasserKhalil. I am looking for an easy solution. that is working fine but since i posted this in the morning today, i've been analyzing the replies i'v got so far. Thanks.

Thank you so much Hui. Can i make this process a bit faster? I would like to run a macro that would extract the values/texts in parentheses to Column B and C and wouldn't show the separated values/texts in Column A. Can it be done?

Hello everyone. Can I have vb code for the following: I have few hundred thousand rows in a column that needs to be separated in two more columns. The column A has information about an order i.e., ORDER 00349O1 (PER KG)***[FISHCURRY]***DELIVERED ORDER 0989378 (PER KG)***[FISHMEAT]***DELIVERED...