macro to skin details of inventory from TALLY SOFTWARE

[makinmomb]

Find attached my file , it is an extract from TALLY SOFTWARE
see column A to H going down to 2o,ooo rows

I need the data see results on J to O that i have manually done for two invoices

I want the macro do me the task

[Artik]

Such slightly twisted macro.

Please Login or Register  to view this content.

Artik

[sintek]

Another Option...
I notice the two different formats CTN and PCS...
Is only (24 in Col C) formatted as PCS

Please Login or Register  to view this content.

[Artik]

I notice the two different formats CTN and PCS...

Oops, actually, I didn't notice it.

I allowed myself to fix the sintek code (it is more understandable than mine) because in the results:
1. I have not received the date in the source format,
2. Values in the third and fourth columns are not numbers.
3. The correct conversion to CTN or PCS occurred only for the specified value (24).

Please Login or Register  to view this content.

Ad.1
Format of my short system date (in Windows) is "dd.mm.yyyy".
When I use

Please Login or Register  to view this content.

in the result area I will get the text, not the date. For example "01-kwi-21" for date 1 April 2021. Only March is an exception as the first 3 letters match

Please Login or Register  to view this content.

But I get dates in the format "dd.mmm.yy" (eg 01.mar.21) instead of "dd-mmm-yy" (01-mar-21).
These are localization problems in Europe where a language other than English is used (not only in Poland). We deal with this problem on a daily basis, so we must pay attention to it.

Artik

[makinmomb]

Thank you artic , wow , it skinned all the details i needed from 3ooo rows and saved me so much time