Close Window   
Free Ebook
Got an Excel Question?
Ask it in our Excel forum!
TeachExcel.com
Subscribe for Free Excel tips & more!
E-mail:
Advertisements



Hyperlink Function With A Match/lookup

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

I have a sheet of names (first name A11 and last name B11). There are many columns of data after the names, but the last column is AG which has notes and comments. I have decided I want to move the notes to another sheet. So I will have on the new sheet at column A5 first name and B5 last name anc C5 Notes.

I would like to create hyperlink to the notes from the first sheet. I tried using Named reference, but I have close to 2000 names anc counting. I looked at HYPERLINK, but I can not get the lookup and or match to work. I have two ways I would like it to to work:

1. I believe this is the hardest of the two. If I select the name on the first sheet that takes me to the corresponding notes on the 2nd sheet.

OR

2. In column AG of Sheet1 I have the text "See Notes" which is a link to the the corresponding notes on the 2nd Sheet.

Also I need the links to be maintained when I sort the rows on the first sheet.

Thanks for any help.

View Answers     

Similar Excel Tutorials

Return the Min or Max Value Using a Lookup in Excel - INDEX MATCH
Find the Min or Max value in a range and, based on that, return a value from another range. This is an advanced lo ...
Best Lookup Formula in Excel - Index and Match
A lookup using INDEX and MATCH is like a VLOOKUP without the restrictions.  Index and Match lookups offer you free ...
HLOOKUP in Excel
The Hlookup function allows you to scan a row from left to right in search of a value and then return the contents ...
Vlookup on Dates and Times in Excel
Perform a lookup on dates and times in Excel: vlookup, hlookup, index/match, any kind of lookup. This tutorial show ...

Helpful Excel Macros

Excel Macro that Searches Entire Workbook and Returns All Matches
- This is the ultimate Lookup Macro for Excel. It will search every worksheet in the workbook and return all of the mat
Delete Entire Rows Based on Predefined Criteria (Text)
- This macro will allow you to specify certain criteria and then to delete rows based upon that criteria. You will choose
Combine Multiple Workbooks into One
- This macro for Microsoft Excel allows you to combine multiple workbooks and worksheets into one new workbook and workshe
Excel Macro to Save a Specific Worksheet as a New File
- This Excel Macro allows you to save a specific worksheet within the Excel Workbook to its own new file. You will be a
Name Worksheets Based on Cell Contents
- This macro allows you to have your worksheets named by whatever is in a particular cell within a worksheet. This means

Similar Topics







I have a sheet with 600+ rows(customers) and would like users to enter in new notes and be able to view old notes along with the date entered.

I am trying to create a page that will allow the user to enter in multiple notes in one row via some kind of drop down that will date the notes as they are entered. This way the user can click the drop down and see all the notes entered for that data set ect.

If this is not possible is there another solution? perhaps a referencing function that displays all prior notes and allows you to enter new notes dating each one?


I'm trying to link my Notes db docs to Excel and it
not working the way I want it to. When I copy a Notes
doc link to Excel, I have to use Special Paste and
paste a Notes Icon (floating)link. It works but what
is needed is a Notes doc link that is assigned to a
cell in Execl, like a hyperlink that is assigned to an
Excel cell. How do I create cell hyperlink in Excel
that links to Notes db docs?

Thank you.




I'm trying to link my Notes db docs to Excel and it
not working the way I want it to. When I copy a Notes
doc link to Excel, I have to use Special Paste and
paste a Notes Icon (floating)link. It works but what
is needed is a Notes doc link that is assigned to a
cell in Execl, like a hyperlink that is assigned to an
Excel cell. How do I create cell hyperlink in Excel
that links to Notes db docs?

Thank you.




I'm trying to link my Notes db docs to Excel and it
not working the way I want it to. When I copy a Notes
doc link to Excel, I have to use Special Paste and
paste a Notes Icon (floating)link. It works but what
is needed is a Notes doc link that is assigned to a
cell in Execl, like a hyperlink that is assigned to an
Excel cell. How do I create cell hyperlink in Excel
that links to Notes db docs?

Thank you



Hi All,

Ive managed to create a spreadsheet that lists sales managers and their clients and can be updated to add new clients from a system report spreadsheet using a macro and advanced filter. One of the columns on the spreadsheet has notes on each client, the problem i am having is when I update the client list and sort it in ascending order the notes become out of sync with their respective client.
Now each client has a client ID number and I was wondering if there was anyway to link the Notes cell to a particular ID? So even after the sheet has been refreshed the notes still link to the correct client?

Thanks in advance


Hi,
Can anyone help me in solving my following problem.

I have few currency notes of different denominations totalling to $4470. I now want to distribute these notes under different lots of $:
150
200
200
220
260
340
440
470
770
1420

The notes I have are of following denominations:
Value Notes
$1000 1
$200 4
$100 19
$50 7
$20 18
$10 6

Is there any functions that I can use to allocate this automatically.

Any hints would be highly appreciated.

Thanks


Hi Guys

I am trying to run a macro which will effectivly pop my notes database up and copy the files then paste them in excel

I have the code to pop notes up


Sub LotusNotes_CVXDocLib()
Application.ScreenUpdating = False
On Error Resume Next
AppActivate "Lotus Notes"
If Not Err.Number = 0 Then
Err.Clear
MsgBox "Notes is Not Running", vbInformation, "WSM-Marketing"
Else
Application.ActiveWorkbook.FollowHyperlink Address:="Notes://address", NewWindow:=True
End If
Exit Sub
End Sub


but I can not get it to select all and copy. Any ideas?


Actually this could be two questions, I suppose.

For a business report I am using MAC office Excel for OSX. Page one is Excel on a landscape format. I need to link (from a "Notes" column) of certain entries to a Word document that is several pages in length.

How do I attach Word document to Excel with each being on separate sheets?
How do I hyperlink from a Notes cell in Excel (sheet 1) to this Word document (sheet 2).


I have a number of tediously long formulae with multiple IF statements. Despite using named ranges for elements within each formula, it is still not always clear what each IF statement is testing for (when I come back to it after 6 months).

Is there a way of adding comments or notes into a formula, without affecting its function? I know notes can be added at the end, but I'm after a way to include them after each IF condition.


I currently have a spreadsheet that I'm using to send information to other people in our plant. I have VBA logic to send the spreadsheet using Lotus Notes and can currently send emails to people who I have added to a specifed cell range. I was wanting to get the names from Lotus Notes by using the group of names set up in Lotus Notes...like "Plant_users". Does anyone know of a way to access the groups? Thanks..


I am having an issue Referencing/Copying/Linking (which would you say this qualifies under?) a Notes section from my Sheet1 to Sheet2.

The notes section is a series of merged cells H9 to H12.

My Formula is : ='U-Data'!H9:H12

This returns : #VALUE!

If I remove the merge from the cells H9 through H12 then just reference H9 in the formula it out-puts correctly. Only issue is the way the notes area will look for others that are using this same excel sheet in the future.

I like the notes area as a text wrap and multiple likes to fit in with the surrounding inputs, and I can not adjust the cell Height without causing an odd look to the input sheet(which is why I am using 3 merged cells).


Is there any way to get this merged cell text over to the output sheet2, or will I just need to redo my whole input sheet1 to allow for a single cell input instead of a merged cell?




Here is an image of the Input sheet:



Set Session = CreateObject("Notes.NotesSession")
Im trying to make a VBA in Excel to send out a massage in lotus notes,
and it stops at the top line with error 494 object out of verl, if i remember right, it was at work. can not test at home. any one know why? it will do this. that can help me out. thanks you.


I have a workbook which has 2 sheets, Data & Template. There are 2 macros, first one imports stationary from Lotus notes to Excel, second does manipulation of data and sends email. In Data sheet, only the first column as email will be constant, rest of the data are dynamic.

---Macro1---

Get Lotus notes Stationary and paste in templates sheet [coded & working]

---Macro2---

---Macro2.1--- [not coded] [Help needed]

Before sending the mail, I need to find words with {nnnnn} (eg. {Name}), flower brackets in template and replace these from data sheet(i have to search the keyword within bracket as it will be column header and get data from that column), Substitute that value in template and send email.

---Macro2.2--- [coded partially & working]

send notes(email)

Hi there,
I am writing a program to examine data stored in a Lotus Notes
database.
The database in question is a fairly adevance workflow system which
produces some lovely MI on what is currently being worked on.
However, currently I have to download the MI to a spreadsheet from
Notes then run whatever analysis I need on it...

This is annoying me...can I get VBA to run the "Export to Excel" action
in Notes??

It also needs to run the action on a particular view, how do I set the
correct view?

Thanks!




Hi Board,

I have a simple form with tasks the users adds, they have a to do by date etc, and also have a notes field. I have created two tables: Workflow (main table) and History (to collect the notes and timestamp them - this table also contains the task title).

I need the notes which the users adds regarding the task, to 'archive' and display in a separate scrolling box on the form - this will be one text field and a timestamp field. The user needs to be able to view all past notes and add new ones,

Can anyone help and point me in the right direction? [Still relatively new to Access - using 2000)?

Many thanks,

Codesurfer




I have edited following [Google] to insert image into Lotus Notes. Its working as far as inserting image into lotus notes
But it gives me error that " No Names found to send mail to. "



Please Login or Register  to view this content.



Hi all,

I need help urgently. I have a macro that opens a excel file and sends itself as attachment through Lotus notes to an user.

If the notes application is on, then the macro works fine, but if the notes application is not running, then it starts the notes application, prompts for the password and then generates a error message saying that the database is not found and stops the macro. even after providing the password.

What I need is that to provide the password for login in Lotus notes should be through the macro.

The process stops and waits for the logon password. I want the macro to give the same and proceed.

Any help will ba appreciated.


Hello,

I have searched high and low for the answer to this with no luck. Before sending an email from excel through Lotus Notes, I would like to ensure Lotus Notes is open. If not open, I would like to leave it closed, but simeply tell the user they must open and log in to their Lotus Notes account. I would be very thankfull for any help.


Hi Excel Masters!

I need some help from you regarding to a sheet I am doing to make for a cavaquinho, a brazilian relative to the hawaiian ukulele!
I am stucked in this part: I have a mini table with the notes that compound a chord, a I want to find the valid combinations that result consequently a valid chord. Let me show the problem to you. Here is the table with the notes of a certain chord, F7M, whose notes are F, A, C and E, and their fret positions in each string (d, G, B, D):


F G H I J 9
F A C E 10 d 4 8 11 3 11 B 7 11 2 6 12 G 11 3 6 10 13 D 4 8 11 3
What I need to implement, is a magic formula that sweeps through the whole table to find the possibilities of chords.
The sequence that represents a valid chord:

-must contain at least one of the compounding nothes - F, A, C or E (in the table it means having one and no more than one value in each column)

-of course, no more than one note in the same string (=no more than one value at each line)

-the notes no more than five frets away from each other (thats a physical limitation from the player`s hand.

In this case, one of the solutions would be:


F G H I J 9
F A C E 10 d 4 8 11 3 11 B 7 11 2 6 12 G 11 3 6 10 13 D 4 8 11 3
What I need its something similar to the for loops in C language. But I wanted to do this without macros...
Anyone has any suggestion?
I am really thankful in advance for your comments.

Thanks,
Martin


Hi,

Well has the code been perfected for the Lotus Notes as when I am using the code in the attachment (See link) that has been enclosed I can only send single mail without any attachment. If I am incorporating the code mentioned above I am getting an error : No names found in cell to send mail to.

http://www.excelforum.com/excel-programming/622045-edit-email-macro-lotus-notes.html
Please enclose a file if the code has been perfected for sending multiple mails with attachments via lotus notes.


I've been looking at this to long, and am having a mental block. I am listing several formulas below, and am wondering if there is a way to combine the formulas into one shorter formula. So it would look through one row of data for a match, if none was found, it would move on to the next range of data, and so on. Thanks for your help. The formulas are listed below.

=INDEX('6'' & ADA Tables'!$F$175:$GH$175,MATCH('Task & Notes Master'!$A11,'6'' & ADA Tables'!$C$174:$GH$174,0)+4)

=INDEX('6'' & ADA Tables'!$F$341:$GH$341,MATCH('Task & Notes Master'!$A21,'6'' & ADA Tables'!$C$340:$GH$340,0)+4)

=INDEX('6'' & ADA Tables'!$F$673:$GH$673,MATCH('Task & Notes Master'!$A31,'6'' & ADA Tables'!$C$672:$GH$672,0)+4)

=INDEX('6'' & ADA Tables'!$F$507:$GH$507,MATCH('Task & Notes Master'!$A36,'6'' & ADA Tables'!$C$506:$GH$506,0)+4)

=INDEX('6'' & ADA Tables'!$F$839:$GH$839,MATCH('Task & Notes Master'!$A8,'6'' & ADA Tables'!$C$838:$GH$838,0)+4)


Hello -

When I click A1, B1, C1, etc. I'd like to have a message box pop up with any notes I have entered into A20, B20, C20, etc. If there's nothing in A20, B20, C20, etc. then I do not need an alert box. Esentially I need something that alerts me that I have notes and need to do something about them. This is a tracking spreadsheet that I am continually forgetting to look at the notes on.

Any suggestions?


Hi all,

I need help urgently. I have a macro that opens a excel file and sends itself as attachment through Lotus notes to an user.

If the notes application is on, then the macro works fine, but if the notes application is not running, then it starts the notes application, prompts for the password and then generates a error message saying that the database is not found and stops the macro. even after providing the password.

What I need is that to provide the password for login in Lotus notes should be through the macro.

The process stops and waits for the logon password. I want the macro to give the same and proceed.

Any help will ba appreciated.


I have seen several resources on how to use excel to send mail out from lotus notes. However, I'm struggling/wondering if there's a way to get excel to interact with lotus notes, and take all the attachments in a LOTUS NOTES FOLDER and move them to a folder on the Hard Drive.

Thanks,
-bob


I've posted this in other forums, with NO reponses, so I apologize for cross-posting...

I'm using Excel2007 and Lotus Notes 6.5
(Lotus Notes Designer is no help either!)

Many years ago, a developer for several of our Lotus Notes databases
decided to "Protect" some Authorization data by adding it to the Title of a Lotus Notes "Section".


Sadly, he is no longer with us.

We are in the process of migrating our Databases to another platform, and I am exporting the database to a format that can be merged to the new location.

However, I would like to extract this Authorization from the Title of
the Section.

I've got LOTS of VBA code that opens the Lotus Notes Database,
Loops through the view and selects each document.

I can extract all of the normal "fields" in each document, but cannot
seem to be able to get to the Section(s) and their titles.
(Even though I can access Fields WITHIN the section.)

From what I can gather, I need to use the NotesRichTextNavigator
and the NotesRichTextSection class,

But cannot seem to get any of the examples to work!
Has anyone done anything like this?
Can you provide guidance?