• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VB Code to make DC in required format from system fetch data

Ateeb Ali

Member
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
 

Attachments

  • Chandoo.xlsx
    23.3 KB · Views: 4
need empty two rows on each line (it is requirement by customer)

Can you how is the final result
For example with 228309
from where is coming info about 914 Mtr ???
Sheet "Required Format" must be clean up or do we stick info at the bottom
 
Last edited:
You don't answer to the questions:
1 - Sheet "Required Format" must be clean up or do we stick info at the bottom ???
2 - with 228309 from where is coming info about 914 Mtr ???
 
Dear Sir, may be my mistake, I could not explained in good way, let me try again.

Attached excel file;
It has 03 sheets.
Sheet "System Extracted Detail" this information extracted from system
Sheet "Conversion" this we will use for conversion like when there is article # 8009/3040, on dc, it will appear as "SSP" "21/3" "914 Mtr"
(See attached file, I have highlighted in Yellow)

Final result is DC detail like whenever system extracted detail is updated, DC will be updated, one solution I have also attached as Pivot table (see attached file for better understanding)

I really really appreciate your response and help and look forward for solution on this form which is always helpful for me
 

Attachments

  • Chandoo.xlsx
    23.6 KB · Views: 2
  • Pivot Solution.xlsx
    32.4 KB · Views: 2
Alternatively I make solution, see attached file
Just need to press "DO it" button to sort data then "Lets Go" to make delivery challan
since I am not good in vb, I recorded the code, so if someone can help to shorten the code so it work faster, also if possible to move grand total column after color and need 02 empty rows after every entry, is it possible?
 

Attachments

  • Chandoo.xlsb
    52.6 KB · Views: 2
Back
Top