dynamis_dk
New Member
- Joined
- Oct 20, 2009
- Messages
- 8
Hi guys, after a little excel help again on something to make my list a little simplier at work. Basically I'm tracking computer assets which are tagged with ID numbers so each PC would be IT12345 or IT98568 etc
I wrote a small VB program to use as a front end which generates a csv file in the format:
PC,IT123123
TFT,IT12321
where the first section (PC, TFT) is the hardware type and the last is its tag.
Now often i'll be given a spreadsheet of the kit would should be within a building and asked to comfirm from my list what IT kit on the spreadsheet has been removed from service leaving only kit which we can't find etc.
My solution to this now is manually searching and comparing but this takes time.
I'm after some way i can run a macro etc which takes the value in my opened csv file cell B1 and compare it with every non-blank cell in a workbook. If a cell in the workbook matches B1's value, the highlight the cell in the workbook. Once the loop had checked the workbook, them it would move to B2, then B3 etc until it get to Bx which is emply then stop the process.
Is this too complicated or something which is doable.
I wrote a small VB program to use as a front end which generates a csv file in the format:
PC,IT123123
TFT,IT12321
where the first section (PC, TFT) is the hardware type and the last is its tag.
Now often i'll be given a spreadsheet of the kit would should be within a building and asked to comfirm from my list what IT kit on the spreadsheet has been removed from service leaving only kit which we can't find etc.
My solution to this now is manually searching and comparing but this takes time.
I'm after some way i can run a macro etc which takes the value in my opened csv file cell B1 and compare it with every non-blank cell in a workbook. If a cell in the workbook matches B1's value, the highlight the cell in the workbook. Once the loop had checked the workbook, them it would move to B2, then B3 etc until it get to Bx which is emply then stop the process.
Is this too complicated or something which is doable.
