Dear Sir
One example file is attached.
It has 03 sheets;
System Extracted Detail: This form I get data from system
Conversion: This is just conversion of Article number into 03 different column which we need on sheet "Required Format"
Required Format: In this sheet, I have a button "do it", when we press it, I just need copy information from sheet "System Extracted Detail" like pivot table but Pivot table is not coming in that format, thats why I need VB solution.
I need empty two rows on each line (it is requirement by customer)
I will appreciate a lot if some one can help.
On DC, we will not show article number (which is internal), instead will show "equal to" column from sheet "Conversion"
Regards
One example file is attached.
It has 03 sheets;
System Extracted Detail: This form I get data from system
Conversion: This is just conversion of Article number into 03 different column which we need on sheet "Required Format"
Required Format: In this sheet, I have a button "do it", when we press it, I just need copy information from sheet "System Extracted Detail" like pivot table but Pivot table is not coming in that format, thats why I need VB solution.
I need empty two rows on each line (it is requirement by customer)
I will appreciate a lot if some one can help.
On DC, we will not show article number (which is internal), instead will show "equal to" column from sheet "Conversion"
Regards