Macro to handle big data

A macro that starts at the top searches for whichever cell starts with 'Operation Costs of Item'. Once found, it then copies the number located 1 cell to its left and pastes it 5 rows below that number in column A. And in column B and C of that row just pasted into, content after ' Operation Costs of Item : ' are split into column B and C based on more than 2 spaces between them. There should be a number to the right of the cell that was just pasted on (in column D). It continues to copy and paste the 3 cells values just filled in column A, B and C till the list of numbers to its right ends. It then works it way down and repeats this mechanism for every 'Operation Costs of Item' found. Ensure that values in other cells untouched aren't removed. Thanks

gg.PNG

Before: work.xlsx
After: work end.xlsx

As your attachment can not handle any VBA procedure so where the VBA procedure must be located ?!

I made those changes manually, I need a macro that automates it based on the pattern. You may type out the macro here.

Nevermind this is resolved. Mods, please delete this thread.