Hi everyone.....
I badly need a serious support. Attached is the excel for refernece. I need to search either by hostname or IP from search sheet. And actual data is in another sheet. Once search is clicked, respective data should appear in the search boxes.
And also ping and RDP function should be applied to the pinged IP (IP or OOB IP cell)...
Please advise and support.
Thanks in Advance...
Here is your search feature. I don't understand what you want with the ping and RDP function. Also, you didn't have a column titled Hostname so I guessed column B. If that is wrong you are going to need to change it.
Please Login or Register to view this content.
Hello,
I am needing to know what kind of code I need to write to be able to select data from one page and have my selection and the price of the item pulled through to my summary page. My project is dealing with a certain type of boat and the price of each boat model as well as the option to have three different motors all varying in price. So, what I am trying to be able to do is select any given boat, with its option of motor included, and have that boat and the price pulled through to my summary page, as well as any of the possible options for the boat. Any help is greatly appreciated! Thank you.
Last edited by roundco; 04-24-2014 at 07:08 PM.
roundco, welcome to the forum
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
@ khateeb, you dont necessarily need VBA tp pull in the data you want. If you can keep the headings each side the same (Serial Number OR SL NO each side, but not both), then you could use this formula, copued down. Change the MATCH('SEARCH HOST'!$B10, to MATCH('SEARCH HOST'!$e10, for the 2nd column
Formula:
Please Login or Register to view this content.
I have checked, but unfortunately the function is not happening when clicked search. And I want to ping and RDP for the IP or OOB IP field.
Did you correctly assign the macro to the command button? Did you enable macros? It works for me so there must be something on your end.
I have no idea what this means:
And I want to ping and RDP for the IP or OOB IP field.
can you pleas send back me working sheet..............
Ping is a windows function to check connectivity
And RDP is a function to take remote desktop
Here you go.
That does not require any clicking anywhere, it is a formula and will calc all the time, automaticallyOriginally Posted by khateeb
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks