Forum Discussion
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
In the link, there are 2 excel sheets to show before and after. Thanks!
Mods, please delete this post, this is resolved. Thanks!
