Hi everyone,
I hope someone can help me here. I have a file with multiple rows and columns.
If there's only 1 SKU purchased, line item would be as normal - Cell A2 onwards
But if for example cell A5, there's additional after column T since it has 2 SKU purchased.
I want to have a macro where when there's additional column after Column T, it will add new rows and copy the data above it. Please take note that it can be multiple SKU purchases and doesn't end with only 2 purchase per each line item.
Here's the sample data:
And the should be data:
Thank you so much in advance!
Joane
I hope someone can help me here. I have a file with multiple rows and columns.
If there's only 1 SKU purchased, line item would be as normal - Cell A2 onwards
But if for example cell A5, there's additional after column T since it has 2 SKU purchased.
I want to have a macro where when there's additional column after Column T, it will add new rows and copy the data above it. Please take note that it can be multiple SKU purchases and doesn't end with only 2 purchase per each line item.
Here's the sample data:
And the should be data:
Thank you so much in advance!
Joane