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 and at the same time Column 3 needs to be refreshed and shown without the separated values and that should happen in every worksheets at the same time.
The expected result in Sheet1 should be:
PO Number CUSTOMER NAME ORDER DETAILS () [] QUANTITY INSPECTED
139778 ATLAS ASDLO**** PERKG FISH 23 YES
139779 NANDOS ASDLO**** PERKTN MEAT 55 NO
139780 ATTRONS ASDLO**** PERKG POULTRY 44 YES
139781 VIDVEST ASDLO**** PERKG FISH 33 NO
139782 LORENZO ASDLO**** PERKG FISH 22 YES
So would other worksheets be like this as well.
I have cross posted this at:
https://www.excelforum.com/excel-pr...o-run-in-multiple-worksheets.html#post4634337
But haven't been able to solve it. I have attached the file here so that You can see it and give me a solution. Thank You All.
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 and at the same time Column 3 needs to be refreshed and shown without the separated values and that should happen in every worksheets at the same time.
The expected result in Sheet1 should be:
PO Number CUSTOMER NAME ORDER DETAILS () [] QUANTITY INSPECTED
139778 ATLAS ASDLO**** PERKG FISH 23 YES
139779 NANDOS ASDLO**** PERKTN MEAT 55 NO
139780 ATTRONS ASDLO**** PERKG POULTRY 44 YES
139781 VIDVEST ASDLO**** PERKG FISH 33 NO
139782 LORENZO ASDLO**** PERKG FISH 22 YES
So would other worksheets be like this as well.
I have cross posted this at:
https://www.excelforum.com/excel-pr...o-run-in-multiple-worksheets.html#post4634337
But haven't been able to solve it. I have attached the file here so that You can see it and give me a solution. Thank You All.