Hi All
I have xls abc which has
serverName & serial #
I have 2nd xls, say xyz which has server name but not searial number
how can i find update the serial number of server by looking into abc xls ?
Thanks
Hi All
I have xls abc which has
serverName & serial #
I have 2nd xls, say xyz which has server name but not searial number
how can i find update the serial number of server by looking into abc xls ?
Thanks
Here are 2 xls data say :
abc :
Hostname , serial #
xyz :
Hostname , serial #
Data of serial # is present in xyz but is not in abc xls
thanks
Hi and welcome
without seeing the data layout we can keep guessing for a while.
Please post a sample wbk ( click Go advanced - Manage attachments). No pics please
Thanks Pape , pls see attached files
needless to say the actual data is more complex.. flle1 has serialNumber col which need to get data form file2 , i think vlookup can help but not sure how to use this in my case
thanks
I don't see any serial numbers in file2.
Perhaps the following tutorial will help. Scroll down to the section: "How to reference another workbook in Excel"
There are subsections on referencing open and closed workbooks.
https://www.ablebits.com/office-addi...heet-workbook/
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Hi JeteMc, thanks for reply, i will check & get back on the url , not sure why you did not see 2nd xls col heading serialNumber
But in simple below is how the 2 xls looks :- ( end goal is may be vlookup & fill file 2 serial # by looking at the file # 1 serial info )
File 1
hostname serialNumber LOB app name db name
File 2
hostname serialNumber
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks