Rohith1324
Board Regular
- Joined
- Feb 27, 2018
- Messages
- 114
I have below data in excel sheet (Data 1 - Highlighted in the below screenshot) I would need a macro which can convert the data into Invoice content (Data 2 - Highlighted in the below screenshot).
Logic:
1) Before running the Macro, In Excel sheet "Column I to N" - Highlighted in the below screenshot will be blank (No Headers nothing just the normal cells)
2) In Column A - I have the Unique ID Number so basis on that Invoice Content to be prepared.
3) If you observe each Unique number has multiple categories (Column F - FRUIT, CLOTHES, VEGETABLE, CHOCOLATE, OIL..etc) involved.
4) When I execute the macro the header in COLUMN I to N to be prepared (If I have 10 Unique numbers ((Column A) then 10 Invoice contents to be prepared one below the other - in this example I'm showing 3 Invoice contents).
5) One unique ID number (Column A) if it is having suppose 2 Categories then in 2 Lines Unique ID number to reflect (Column I) and then after removing duplicate Macro to paste the categories.
6) By default, Qty to reflect in the lines as "1 Set" - Standard.
7) For 1 Unique ID Number & Category we need to take the Value and paste it under both Unit Value & Total Value columns.
8) Finally in the Column N Passcode of that Category must be picked from Data 1 and then update the Invoice content Data 2.
9) For each unique ID separate Invoice content to be created with Numbering as Invoice 1, Invoice 2, Invoice 3
Please help me with Macro...
Logic:
1) Before running the Macro, In Excel sheet "Column I to N" - Highlighted in the below screenshot will be blank (No Headers nothing just the normal cells)
2) In Column A - I have the Unique ID Number so basis on that Invoice Content to be prepared.
3) If you observe each Unique number has multiple categories (Column F - FRUIT, CLOTHES, VEGETABLE, CHOCOLATE, OIL..etc) involved.
4) When I execute the macro the header in COLUMN I to N to be prepared (If I have 10 Unique numbers ((Column A) then 10 Invoice contents to be prepared one below the other - in this example I'm showing 3 Invoice contents).
5) One unique ID number (Column A) if it is having suppose 2 Categories then in 2 Lines Unique ID number to reflect (Column I) and then after removing duplicate Macro to paste the categories.
6) By default, Qty to reflect in the lines as "1 Set" - Standard.
7) For 1 Unique ID Number & Category we need to take the Value and paste it under both Unit Value & Total Value columns.
8) Finally in the Column N Passcode of that Category must be picked from Data 1 and then update the Invoice content Data 2.
9) For each unique ID separate Invoice content to be created with Numbering as Invoice 1, Invoice 2, Invoice 3
Please help me with Macro...