|17 Dec 2013||#1|
| || |
Excel advanced conditional editing help needed
I have two excel files. One is inventory and other is ip plan.
The inventory document has a alot of data. Of them One column is of computer name and second is ip.
The ip plan has one column consisting of ip and next to it the user name and some other information.
Now I want the ip plan document to also have a column for computer name.
For this i will have to look at the ip column in ip plan file for first ip. Then search the inventory file for that ip. Once that ip is found in inventory file there is a machine name next to it. I will have to copy it and paste it next to ip plane file.
How can i do it. Any clue? I have not used excel so deeply.
|My System Specs|
|Similar help and support threads for2: Excel advanced conditional editing help needed|
|excel 2010 conditional formating||Microsoft Office|
|Excel Guru Needed - Help with order form that will update an inventory||Microsoft Office|
|Some little help on editing this needed||Customization|
|MS Excel Urgent Help Needed||Microsoft Office|
|Cant scroll while editing formula Excel 2007||Microsoft Office|
|Our Sites ||Site Links ||About Us ||Find Us |
© Designer Media Ltd
All times are GMT -5. The time now is 09:59 PM.