gabo53
10-22-2012, 02:22 PM
Hi,
In new to vba and just a regular user of Excel, I have a text report generated by a third part software, really messy, by now I've got created (using VBA) a new text file with the requiered data separated by "pipe" symbols, now I'm stuck with what is really need to be done, I need to look in each line for info and operate the next lines, e.g.
Data structure: Level | Description | Qty
Data Sample:
1 | Desktop PC... | 2
2 | DVD combo | 1
3 | Sata DVD-R... | 1
3 | Sata Cable | 1
2 | HDD | 1
1 | LCD Monitor | 5
And so on... so what I would need from that data is the products that actually are going out of inventory, from that i need qty of the products and descriptions, i.e.:
Sata DVD-R... | 2 (multipliying 1 unit for each PC)
Sata Cable... | 2 (...)
HDD | 2
LCD Monitor | 5
I'm not so interested in "code" because I want to understand and learn, but I don't know how to proceed.
How can this be done?
The data would be used in Excel, would be easier operate the data before or after importing to it?
Any help would be highly appreciated, thanks.
Sorry for the long post but I wanted to be as clear as posible :)
In new to vba and just a regular user of Excel, I have a text report generated by a third part software, really messy, by now I've got created (using VBA) a new text file with the requiered data separated by "pipe" symbols, now I'm stuck with what is really need to be done, I need to look in each line for info and operate the next lines, e.g.
Data structure: Level | Description | Qty
Data Sample:
1 | Desktop PC... | 2
2 | DVD combo | 1
3 | Sata DVD-R... | 1
3 | Sata Cable | 1
2 | HDD | 1
1 | LCD Monitor | 5
And so on... so what I would need from that data is the products that actually are going out of inventory, from that i need qty of the products and descriptions, i.e.:
Sata DVD-R... | 2 (multipliying 1 unit for each PC)
Sata Cable... | 2 (...)
HDD | 2
LCD Monitor | 5
I'm not so interested in "code" because I want to understand and learn, but I don't know how to proceed.
How can this be done?
The data would be used in Excel, would be easier operate the data before or after importing to it?
Any help would be highly appreciated, thanks.
Sorry for the long post but I wanted to be as clear as posible :)