| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding data to a cell next to another cell with specific value
Hi I need to know how I can do the above.
Example I have a list of Ip Address 10.70.60.121 , 10.70.60.125 , 10.70.10.50 etc Now What I want to do is using a Macro if posiible add a cell next the the one containing the IP address which will give me the location that I will specify it should be . Reason for this is we get a lot of lists with Ip address and we can only see where these IP belong by manually searching the Gateways and then typing the Sites in the next Colums next to the Ip colums .. will make my life easier if I can run a Macro that can do this for me ... Any help will be appreciated. Regards Gerhard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
| Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing | Excel Discussion (Misc queries) | |||
| how do i find specific data in a cell and its colocated cell data | Excel Worksheet Functions | |||
| Send data from userform to specific cell on specific sheet? | Excel Programming | |||
| Lock data in a cell a specific cell based on selection on other ce | Excel Worksheet Functions | |||
Threaded Mode
