how I can use a hyperlink to access a particular sheet of another workbook? for eg, I have 2 workbooks, A and B.' A ' has a set of 15 hyperlinks. When I click the first link in 'A' it should open sheet 1 in 'B' and when i click link 2 it should open 'sheet 2' in 'B'. How can I do that?
View 6 RepliesI have excel worksheet with 2 sheets in it. Let’s call the one "Database", it consist of 713 rows and 15 columns with data in of my product. Then the other one "Display Product" in it you type in the code of the specific product so it search for my code and display all of the information of that product code on the "Display Product" sheet and it that work.
Now I want to link a picture to that specific product to the code. Here's the code I used:
Private Sub Worksheet_Calculate()
Dim oPic As Picture
Me.Pictures.Visible = False
With Range("A71")
For Each oPic In Me.Pictures
If oPic.Name = .Text Then
oPic.Visible = True
oPic.Top = .Top
oPic.Left = .Left
Exit For
End If
Next oPic
End With
End Sub
Now this code works fine up to a specific limit in my case 66 picture to a product, and I need at least 200 more images in it but I get a runtime error in my macro when I put one more image in. This is where I get the run time error -> “Me.Pictures.Visible = False“.
I don't know if excel is limited to image usage. Or maybe there is another way to do what I want to do with more advance coding.
Basically, I have a large spreadsheet with basic data including names, dates and a unique identifier number (UIN). I have created a questionnaire in a userform (with a UIN txtbox) and want to link the answers to the specific individuals on the worksheet.
i.e. If UIN 201 fills in the questionnaire on the userform it will enter the details on the spreadsheet next to the details already entered for UIN 201.
I have a list of terms to put together and what I have is a master list of 6 concatenate functions and I need to link them to all the different words in my list.
The first word in collumn A needs to be with the function in D1, the second word (A2) needs to be with D2, then A3 with D1, and A4 also with D1, while A5 with D6, etc.
It looks something like this:
for your info...I have put numbers in the adjacent cell corresponding to which of the 6 concatenate functions need to go into the cell in collumn C
So in reality all I need is a function that would rearrange my list of 6 functions from Collumn D into collumn C based on the numbers 1-6 I have in collumn B
Workbook.txt
(attached is an example to better see what im talking about. Disregard that the concatenate functions are not working...it doesnt matter right now.)
This time I need to be able to reference a specific cell in the preceeding row of a GETPIVOTDATA formula. This is shortened example but it shows what I am trying to achieve:
A B C
NAME ID FRQ
Spellbound 1234 W
Spellbound 1234 W
Spellbound 1234 W
The GETPIVOTDATA formula is located in C6 in this example and needs to reference B5 i.e. the last ID cell reference. I need to work the formula this way as it will be placed at varying intervals in column C and the preceeding data for each NAME will vary as to how many rows each NAME contains.
There is a problem in joining one cell to the other file
The below is screen shot when l click the on every cell the image must be open
How can do it?
Capture.PNG
Is it possible to have a macro create a hyper link once data is entered into specific cell, i have a multi sheet work book used as a stock card system.
Each stock item has its own worksheet and the product code is entered in to cell E3
(which in turn has a macro in it to change the sheet name to match the product code).
the macro also inserts a row of info into row 5 of another sheet used as a summary sheet ( CONTROL.SHEET or SHEET 4) using copy and paste link.
i need a macro to generate a hyperlink in cell D4 of the control sheet between the row info and the matching product code sheet ( the product code is displayed in cell E4 of the control sheet.
I only input one item at a time and then manually cut and insert the row info into the stock list on control sheet. so every time i input a new item, the row info is always in row 5 of the control sheet.
I have worksheet1 with 200+ customers and 12 months of data for each customer. I want to link each month to a separate worksheet (worksheet2, 3....12) for all customers. (i.e., customer 1's January activity across row 1, customers 2's January activity across row 2.....)
Is there a way for me to create a formula or copy comand to link row1, worksheet1's data to row1 worksheet2 and then every 13th row in worksheet1 to row2, row3...in worksheet2?
Right now I'm just putting the = in worksheet2 and mousing over to worksheet1.
How can I link 2 sheets in excel? If I have 2 different rows in 2 different sheets and want to calculate the difference between them (THE ROWS), i.e. On one sheet i have a number lets say 4 and on the other sheet I have 8. On one of the sheets (doesnt matter which one) I want to calculate the difference which in this case is 4. And automatically when I change one of the numbers the difference also changes automatically..
View 5 Replies View RelatedI have a workbook that I am trying to get easier to work with, I have sheet 1 that my product codes,cost,mark up % and amount sold etc. and I have sheet 2 that has suppliers order No's, Cust name/email etc. and the At the moment in my example I manually hyperlink AE2 in sheet 1 to A2 in sheet 2 - and I manually copy cells P2 & Q2 in sheet 1 and paste link into E2 & F3 sheet 2.
I want cells E2 & F3 in sheet 2 to automatically link to their corresponding cells in sheet 1 P2 & Q2
Can you link a cell to a sheet tab. If yes how?
View 4 Replies View RelatedI have a sheet with a bunch of company information, Name, address, phone, email, etc.
On another sheet I link back to this sheet with =DATA!A1 and copy down.
Although the cell that has the email address on the DATA sheet is a working link to open Outlook, it does not give me that link when brought to the second sheet.
Is there a formating tip or something else that will do the trick. I have looked though searches and all I could find is creating Hyperlinks. I don't think that is my answer because on my Second sheet I will be coping from a different set of cells the next time I use this workbook.
Is it possible to link a sheetname?
I have a list of employees on sheet1 and each employee has there own sheet with their name as the sheet name. Each sheet contains a form that the employees need to fill in.
I have created several extra sheets for new employees and I would like these sheet names to be linked to a cell on sheet1. This way the only updating I need to do when receiving new employees is enter there name to the list in sheet1.
I've created a chart in sheet 1 in a workbook. I want to copy and paste that chart into another sheet (lets take sheet 2) of the same workbook. I am using Excel 2010 version.
Whenever, I try to copy a graph and want to do "Paste Special as Link picture". The problem I am facing as "Paste Link" option is inactive.
I am attaching the Excel for your reference.
i have attached my sample spreadsheet that i need to have a code to link to specific cells value.
whenever i click on the command button on beside Activation 1 it will go to Activation 1 sheet/tab.
I've created the form and formatted everythig as I need it but now I am clueless how to make the command button (enter data) post the data to the appropriate cells in my spreadsheet. I especially need the data to find the first empty row so that it doesn't overwrite the previously entered information.
View 11 Replies View RelatedProject is shared, cannot use vba.
I have in A2 - A12, The names of different sheets in the workbook. I would like to create a link so when a user clicks on the cell, it will take them to the specified sheet.
Lets say cell A2 contains the text '1208', when pressed I would like it to open up the sheet 'A1208'
So I have a set of data in my sheet 2 that I want to be connected to sheet 1. The data in sheet 2 looks like this,
NO
Reaction
H
S
1
2Fe2O3 + 3C = 4Fe + 3CO2
105690
120.21
2
Cr2O3 + C = 2Cr + 1/2CO2
218,085
59.24
while in sheet 1,Reaction No
Carbothermic Rxn
H
S
What I want to do is that when I put a reaction no (e.g 1) at the empty cell next to the label Reaction No, the data in sheet2 (i.e. Reaction, H and S) would automatically be reflected in the empty cells next to Carbothermic Rxn, H and S.
I have created 10 Hyperlinks in sheet 1. And all these links in the same sheet. When i copy the same sheet to sheet 2, the sheet 2 hyperlink is related or is reffered to sheet. Is it possible that when we copy teh sheet to next sheet, the hyperlink also gets copied with the sheet number
View 2 Replies View RelatedI'm trying to open a web link from my excel sheet in Mozilla firefox. But each time I try to open the link it opens in Internet explorer eventhough I've set mozilla as my default browser.
How could I write a code that would open the link in mozilla firefox.
I'm trying to write some code that links to certain sheets if certain cells are clicked. My sheets are named "01", "02", "03", ... , "20", ... "XX". I'm hoping I can use some loops to reference the names of the sheets since they are in a number format, but "j", which is how I tried to link cell rows with a corresponding sheet, in the code below doesn't cooperate. fix this or can you simply not reference sheet names this way?
If ActiveCell.Column = 4 Or 5 Then
For i = 5 To 7
j = i - 4
If ActiveCell.Row = i Then
Sheets("0j").Activate
Exit Sub
Else
End If
Next
Else
End If
once I get the pretty boxes and such, how do I link this form to a sheet to record data? How do I get it to run? I have tried searching the forum, but it seems that most of you already know that part and don't have any problems there.
I know this is probably very very basic and I will smack my face with my hand when you point it out. I just have never created forms with Excel before. I am used to using SalesLogix and when I create forms there, I have a database table that I can link each field to, so I keep looking for how to link to the table and I can't figure it out.
I am trying to create a sheet with 'buttons' on, a bit like a 'linked table of contents', that will take the user to individual sheets (as opposed to clicking on the sheet tabs). I can see how to place Command buttons on a sheet (in this case Sheet1), but I think I need help with the code to make the buttons function as I envisage. Is this in the scope of help via this forum?
View 9 Replies View RelatedI have a dynamic named range named ’db’ in sheet1. I need to have the same range linked to sheet2 starting in cell A1.
View 3 Replies View RelatedI have 4 sheets from sheet1 to sheet3, I typed code date and quantity which the code has 5 columns. In sheet 4 I have defined dropdown in I2 Cell(yellow fill) which has all code fromsheet1 to sheet3. So my purpose is that in sheet 4 I want to select code in I2 cell then it will appear in code column date and quantity automatically for the last cell of date and quantity. Note: I'm looking only the last cells when I select the code in dropdown.
View 6 Replies View RelatedIs there a way to link a header or a portion of a header to a specific cell?
View 14 Replies View RelatedI have a formula in a cell which is refered to other cell within the same sheet and also to other sheet from other file. say
C1 = A1+B1+data file c1 Data file is another file in other location.
I was trying to break a external reference link (from Data File) from Data _ Edit Link, but it is converting all the formula to value. How is it possible to break only the external link without damaging the formula within the sheet say c1 = A1+B1+26 (value from data file c1)
I need to create a Macro that will link Horizontal data to vertical data in a separate sheet. Here's the Example:
I have data in a forecast spreadsheet that is horizontal, So, J2:U2 (12 columns for 12 months). This row of data needs to be linked in a single column of data on a separate sheet called "Price_Quantity". So I need C3:C14 (in price_quantity sheet) to be linked to the data in J2:U2 (in forecast sheet). Then C15:C26 needs to be linked to J3:U3, so on and so forth. 12 rows linking to 12 columns. All the way until C4959:C4970 is linked to J415:U415.
I'm trying to make a floor plan which shows what seats are available depending on the time it is. So I made sheet1 = to the map (where the seats are located), sheet2 - rows = seat #'s, columns = Time (broken down by half hours). Now i have conditional format to show "t" in red (which means taken), "f" in blue (which means free), and "n" to show in gray (which means not working).
What i need is example - Seat # 200 in sheet 1 to show red, blue, or gray depending on the value in the row that corespond to this seat and the column that corespond to the current time.
I'm trying to create a formula that takes from "Manual" Sheet the number from colume G2 and multiply it by the percentage in sheet "AllocationRule".
My formula currently is =Manual!$G$2*AllocationRule!$B5.
What needs to happen is that the total number in "Manual" needs to be distributed evenly in 4 rows by the percentages allocated in "AllocationRule".
Right now I can't copy my formula over to the sheet because the "AllocationRule" should stop at B5 and not go further and the G2 from "Manual" should not change for the percentage allocation but should change to the next row for the next month.
And then after I've done the calculation I want the LOB in "AllocationRule" to be displayed in the LOB in "H1913_H1914" but I'm not sure what formula to use.