i have an excel file that has several worksheet tabs most of which i have hyperlinks running on them, what i need to do is colate a couple of the sheets to a seperate excel file but when i try to copy them from the original file to the new file they will not copy because the info is hyperlinked!
View 9 RepliesIf, say cell A1, contains text such as:
"This Forum is wonderful, to see a great example for a post click here." <This is not an actual link here!>
Is it possible to have the "click here" part as a hyperlink, and not the entire cell?
Or- do i have to add an "image" or something similar to which i can add the hyperlink and then anchor the "image" to that cell?
Is there any way I can make it so an image is hyperlinked to a cell with specific text entered. After clicking on the image, the cell where the image is hyperlinked to changes text.
For example:
An image of a strawberry is hyperlinked to a cell which contains the word "strawberry".
After clicking on the strawberry image, the cell which contained the word "strawberry" now contains the word "strawberry1".
If you understand that, I would so love the help.
I also posted this is question here
http://www.excelforum.com/showthread.php?t=637811
I am trying to send email using and excel macro.
I would like to send an image that has a hyperlink in an email, so when the user receives the email they can click the image and it will take them to a webpage.
The code I have so far is this
With OutMail
.Attachments.Add "C:PanelImagesEmailer_EN.jpg"
.Save
.SentOnBehalfOfName = "Email@Address.com"
.To = cell.Value
.Subject = cell.Offset(0, 2).Value
.HTMLBody = "" & _
"IMG src=cid: Emailer_EN.jpg"
.Display
.Send 'uncomment to send
If I put text in the area after the link then the text appears as a hyper link.....
I currently have one spread sheet. At the top of that spread sheet there is an object that hyperlinks to cell A180. When i click that hyperlink, it take me to cell 180, but it appears at the bottom of the spreadsheet, rather than bringing it all the way up to the top of my current viewable screen.
View 3 Replies View RelatedI have a workbook full of several tabs. The main tab is the 'Report' tab, all other tabs are hidden. The information on the hidden tabs populate onto the 'Report' tab.
My question is, I have created a shape on the 'Report' tab to act as a button. This "buttton" is which I have hyper-linked with one of the hidden tabs. When the hyper-linked tab is showing, the button works fine. However, when I hide the hyper-linked tab, the button does not work. I would prefer to have just the 'Report' tab showing.
I have a table of many rows and columns of information, some of which is hyperlinked to seperate sheets in the same workbook, some are not hyperlinked at all. What I want to do is select a column and when a hyperlink is found going down the column, copy the sheet that it is linked to into a new book, then find the next hyperlink and copy that sheet into the same book as the first one. So if I have 25 hyperlinks in the column, I finish up with a new book containing 25 sheets in the order they were found. Hope someone can help me with this, it will save me hours of work.
View 9 Replies View RelatedColumn C (starting at row 5) contains hyperlinks. I want to print the linked file, move down to the next cell, print that file, move on to the next, etc. FYI - The worksheets are from a seperate file.
View 2 Replies View RelatedIve spent a few hours adding email hyperlinks to data in column B.
I now want to sort the data in the worksheet into ascending order using the data in column A.
The problem is, none of the hyperlinks from column B sort with the data in column A, they are still in the cell locations I had originally entered them.
I have text from subjects in rows, and I need to fill out the empty spaces with the specific text. For example my data looks like this:
Name1
Name2
Name3
Name4
Name5
Name6
I need it to fill out the empty cells below each name, with the top name so it looks like this:
Name1
Name1
Name1
Name2
Name2
Name3
[Code] ......
For example, one can see that Name3 has no empty cells below, hence it should just move on to the next (name4) etc.
When I add a text box in Excel 2007, when I type the text box, instead of the cursor moving forward as I type, the cursor stays in the same place and the text moves backwards.
when I try and navigate back through the text, pressing right will make the cursor go left, pressing left will make the cursor go right
At this point, I have a list in the first column that looks something like the following:.......
First, I want to delete any cells that have two or more '' characters and delete any cells that do not have any text after the first '' character. Then I want to take the text before the character and put it in column B, deleting the ''. Once I have done these things, my original post and this one can be marked solved.
I have an excel work book with 6 tabs. I would like to have Excel move an entire row from one tab to another tab (removing the row and inserting it in the other tab). I.e. Example I have a tab with items that are marked as "Open Actions" so if I were to change the drop down to close. Excel would move that entire row of actions to the tab with the "closed actions" and insert into the next available row. Now if someone were to come back at a later date say no it should be reopened than I would change the drop down to open and excel would move that row back to the open actions tab into next available row. I tried a PIVOT table and no good I played with few macro and not.
View 5 Replies View RelatedCan I have text moving in a cell similar to a news flash.
View 3 Replies View RelatedI would like to make a macro that will move rows from one worksheet to another worksheet.
I have an excel spreadsheet with multiple columns and rows, within one of the columns there is some text that refers to SOS or County, I need to move everything that has SOS to another worksheet title UCC SOS and everything that has county to be moved to another worksheet title UCC County. Here is a sampling of the worksheet
Account
Primary Borrower
Corp
Status
[Code]....
Moving Colored Text within a automatically adjusting table containing More Than 3 Colors, from Coloum to Coloum. i have managed to put this little chart together to use on our gaming wedsite but i would like to go one step further with it. may table automatically moves the colums up and down the table as i enter the infomation in to it,, "but" I the colours in the text do not stay the same as they move up and down the coloums. how to make the coloured text keep its colour in the table as it alters its position in the table
View 9 Replies View RelatedI need to remove numbers from a string of text and put them into new cells in Excel Starter 2010. There are two different values which need moving. The first is in parentheses and the second follows the parentheses.
Here's a few examples of what I mean:
Original text
RED008 - Wickaman and Hoodlum bandwidth (0.06Gb @ 2.00) 0.12
MFR005EP - Various Artists bandwidth (0.19Gb @ 2.00) 0.38
RAZORS010 Future Cut bandwidth (0.01Gb @ 2.00) 0.01
would like to split into...
Cell 1
RED008 - Wickaman and Hoodlum bandwidth
MFR005EP - Various Artists bandwidth
RAZORS010 Future Cut bandwidth
Cell 2
(0.06Gb @ 2.00)
(0.19Gb @ 2.00)
(0.01Gb @ 2.00)
Cell 3
0.12
0.38
0.01
I have a list of job names in a column. All names contain hyperlinks to a corresponding file. I need to retrieve the value of "C2" in each hyperlinked file and place it next to the original job name.
View 6 Replies View RelatedI am running Win XP and Excel 2003.
I have a macro I found here on the boards written by Lenze to delete an entire row based on what is found in column A. I would like to delete any row where Col. B contains 10 or less characters and I have modified it to do so (or at least I think it does). My problem is that it takes about 12 minutes to run the macro (I have about 50k lines to run through). I was wondering if this is the fastest method or if it examines things other than just column B.
Sub Test()
Dim i As Long
LR = Cells(Rows.Count, "B").End(xlUp).Row
For i = LR To 2 Step -1
If Len(Cells(i, "B")) < 11 Then Cells(i, "B").EntireRow.Delete
Next i
End Sub
After this runs, I am left with Columns A to somewhere around AH. The columns are generally in the format of text followed by a numeric column. An individual text column has the same name through all of the rows. The numeric columns have varied values whether negative or positive.
Ideally what I would like: If a given cell (ie. C2) in Row 2 is numeric, then copy the cell to the left (ie. B2) into (ie. C1) and then delete Column B. I need this to work for multiple columns from B to C, skip D and E, and then from F to AG (and maybe beyond).
I have a cell that has text added to the cell using a function. I need to move the cell to a different location, but without the text.
View 1 Replies View RelatedLet's say there's a couple row:
[Code].....
Here's a column I will be pasting:
[Code] ....
If I want to "Insert Copied Cells" in place of Yellow on Row1 and shift the cells down, the rows would look like this:
[Code] .....
How can I make it so the rows would be the following during such a paste:
[Code] .....
This is because I have hundreds of cells that I need to insert as columns all the while pushing complete rows down. If you're trying to understand why, it will be for some online marketing purpose as demonstrated here in this sheet: [URL] ...
I am unaware how to set up a combo box to allow users to move from the combobox to the next combo box . tab or enter? The way we do it know is we click with the mouse from combobox.
View 3 Replies View RelatedI have a workbook with 2 work sheets, when a row has "yes" typed into the "accepted bid" column I would like that row to be placed into the second sheet in the order in which it was entered "yes"
so, if on the first sheet a row, lets say row 10 had "yes" typed into it but row 10-15 on the second sheet had something in it already, the info would have to be placed in the next available row.
I have approximatley 20 rows on the first sheet and the ones that transfer to the second can just be added to it as needed.
I want to move the vales from F8 to F9, F9 to F10, F10 to F12 (there is a space)and so one. I would like it to be triggered by changing the value in F8 if possible. I have tried a good few ways, sometimes I get a stack 28 error.Zones.xlsm
View 6 Replies View RelatedIs there a way to write VBA code that can reference a range of data that may be moved on the spreadsheet by the User? For example, if I write VBA code to reference a range of data such as:
View 2 Replies View RelatedI need to know the function to move a named sheet to the end of the list so its the last sheet in the workbook. Worksheets("xxxx").Copy After:=Worksheets(?)
Im copying a worksheet and want to move the new sheet to the end but I dont know how to finnish it. I tried to do.
name3 = Worksheet.count + 2
Worksheets("xxxx").Copy After:=Worksheets(name3)
but I get an error and cant debug it.
I am very new to macros I have a list of data all in column D. I need the macro to go through that whole column and for any cell with more than 50 characters stop at 50 and continue the remaining text in the cell below. This can all happen in column E.
View 8 Replies View Relatedthis User Defined Function (UDF) would operate on any specified data (ignoring blanks) over a range. Inputs to the UDF are range and period.
View 9 Replies View RelatedI have a matrix A with 12 rows and 10 columns. My problem is if in the cell(i,j) there is data then the same data should appear in a similar matrix B, but in a cell which is 15 cells behind the cell(i,j).
That is it should start counting upwards from cell (i,j) in B and once it reaches the top of the matrix it should continue counting from the bottom of the immediate left column and go up. When it reaches the 15 cell from cell(i,j) in b, it should print there the value that was in cell(i,j) of A.
I have created a simple button that I want to take me to a certain number of tabs.
I have about 24 tabs. I can't see them all. I create a button that will take me to a specific tab from my main page. This works fine till I rename the tab. I want the code to read a sheet number or something like that instead of the specific name.
Sheets("JobList").Select
Range("A8").Select
This works till i change the name "JobList"