Hi to all
I need some help with hyperlink that should point to specific cell in another sheet
In Sheet1 I have a row with dates like you can see in the picture:
It start from first week of year in A2 (31/12-06/01/2024) and finish in FI2
In Sheet2 I use this formula to jump to a specific...
Ok, all, first time posting on any forum. Just been sitting in the back, reading and learning. But now I'm stuck and decided to ask for help.
I need to assign a created image with a hyperlink to a hidden sheet, using a variable address based on the value of a cell. EV36 would be the location of...
Hi guys.
Is there a way to edit the below formula so that the worksheet name is referenced to a cell?? - "2020" is a cell.
=HYPERLINK("#"&ADDRESS(MATCH(A4,'2020'!A:A,0),8,1,1,"2020"),"Link")
Good Morning,
I am trying to hyperlink to google maps but in doing so I am also trying to substitute two values (postcodes) on my spreadsheet into the address from and the address to.
For example:
=HYPERLINK("https://maps.google.co.uk/maps?saddr="&SUBSTITUTE(C8,"...
<tbody>
A
B
C
D
...
X
Y
Z
AA
1
2
Dates
8/30/16
...
4/13/17
4/14/17
4/15/17
4/16/17
3
Description
Start Date
End Date
4
Foundation Concrete Pour
4/13/17
4/16/17
20
20
20
20
5
</tbody>
I have a table with items and the time each takes to be...
Sub Report()
MsgBox "Report is ready to use"
End Sub
So far I have something like this, but I would like to add a hyperlink of report's path.
If the report's path is C:\Program Files\Acute Data_1000.xlsx is it possible to include a hyperlink on the message box?
Thank you!
Hi ! Greetings from Paris :) !
I've just started playing with VBA, macros, and all this stuff on excel.
I've created this macro:
Sub MiPrimeraMacro()
With Worksheets(1)
.Hyperlinks.Add Anchor:=.Range("i2"), _
Address:=("http://www.apple.com/" & Range("i2")), _
ScreenTip:="Apple link"
End...
I am using Excel 2003
I use the next method to open a file located in the same folder of the current xls file
right click, hyperlink, choose Existing File or Webpage, choose desired file
but I want to open a file in a folder relative to where the current file is located, so when they are moved...
Hello All,
I'm trying to create a series of Macros that take the contents of Column E, puts a direct hyperlink to website in question.
I just can't seem to find the code online to help me achieve what I want.
This is the code I have so far.
Dim sh1 As Worksheet
Dim...
hyperlink w/in excel loses reference
this is the situation
person cell id hyperlink
Adams b20 b20
Jones b50 b50
Zilch b99 b99
If I create a hyperlink at Zilch to Jones the hyperlink = b50
then if I add a person above Jones (b50), the Jones info moves down and...
Hello dear
I have a hyper link in cell A2. Value of the cell is "1st link" and hyperlink address is "http://1stlink/add.php".
Now I want that valu of B2 cell will be "http://1stlink/add.php"
I want to do that work in vba.
How can I do that, plz help me.
Hi all,
I have a question that I have not been able to work out. I have a 9 digit number in cell B2 and need to set the folder in VBA based on the number. Part of the map involves the first number of the 9 digit number so as an example:
Cell B2: 231231231
Folder map would be...
Hi Board of Genius'
Can anybody help me to achieve this, at all, please?
I currently have a Hyperlink Cell (C10) which, when clicked, takes the user externally to Google maps at the address as inputted into a number of Cells:
User Cells:
B6 = "House Name / Number"
B7 = "Street"
B8 = "Town"...
I have an Excel report 'Report A' which contains hyperlinks to other files. The hyperlink is also copied from 'Report A' to 'Report B' and other reports which are distributed to users. Therefore the hyperlink needs to contain the absolute address.
Excel replaces the absolute address with a...
I am creating a yearly report for my company, and I have an email column that we can enter in the individual’s email address in the cell. When we click on the email address it does what it is supposed to do; however, I want to go a step beyond that. I want the email to prefill the subject line...
Hello people,
I am having a bit of trouble inserting a dynamic hyperlink into an Email that will be generated from Excel, linking to a newly saved document. there is a macro, which seems to work fine, calling a function that seems to hold the error. here is the macro: (Please note that the...
Hi All,
I have a spreadsheet with 15 sheets and this includes a 1st quarter, 2nd quarter, 3rd quarter, 4th quarter and monthly report sheet. The quarterly sheets have around 1,000 lines and list a lot of expenses and income by different categories. The monthly report sheet takes the total of...
i use PC and a couple of my clients use MAC.
I use Office 2010
Clients use 2011
it seems that when they take a spread sheet that I make for the and they save it as another name on the MAC, the hyperlinks disapear. Any way to prevent this?
Hi Folks,
I am trying to make a workbook that will basically be a document index to files on a network drive.
So what i wish to be able to do is have a button on the worksheet that will check for the next empty cell in a coloum and then open a browse window so i can look for a file on the...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.