Good afternoon dear, I have a project in hand where I have four worksheets, one of each "computer station management program" in which, in all of them, I have a column with the patrimony number of the machine. p>
The vast majority of machines are in the 4 worksheets, but some are not, and that's my goal. I want to get these 4 worksheets and put them in one, where I will have only 4 columns (of the 4 programs) and in the rows of these columns I want to put the number of assets if it is present in the table referring to that column, leaving blank otherwise .
I would like this new table to be in ascending order of equity, and for example 12345 - 12345 - 12345 in line 12345, assuming that it is not present only in the third column. >
I'm using jexcelapi, however I'm a bit lost in HOWTO do this mapping, in order, and so on. Anyone have any tips? I have no doubt about the code, just the logic of how to structure that program itself.)
Thank you!