Hi All,
So, I'm currently putting together a CSV file which is around 50k lines
I am having to copy and paste product codes manually into a certain number of cells and then move down to the next product code.
Does anyone have any advise on how to write a formula or is able to show me some vba or macro that i could use to enable it to copy and past down automatically and then know when to swap to the next product code?
So the new product code renews every time the column on the left says black.
Any help would be very much appreciated as this is taking a huge amount of time up
So, I'm currently putting together a CSV file which is around 50k lines
I am having to copy and paste product codes manually into a certain number of cells and then move down to the next product code.
Does anyone have any advise on how to write a formula or is able to show me some vba or macro that i could use to enable it to copy and past down automatically and then know when to swap to the next product code?
So the new product code renews every time the column on the left says black.
Any help would be very much appreciated as this is taking a huge amount of time up