Hi! I have an inventory sheet with data. Then I have a book, where each page has multiple cells relating to a line item on the inventory sheet. Rather than manually link 100 pages, how to I duplicate each page and have the multiple cells magically refer to the next line item?
I am having a sheet in which I want to hyperlink a cell such that it finds text mentioned in formula and moves cursor there
For this I am using below formula
=HYPERLINK("#ToDo!A" & MATCH("promc1",A:A,0), "display text")
Above formula is entered in cell A53
Todo is sheet name in the same...
Yesterday I posted a similar question to this one but figured more context is needed in order for a solution to work for me :(
For context, I have data in a primary table structured like below:
I want to be able to make cells move together if I change the value of one of the headings. I currently have the heading set up to come from another sheet using a vlookup. When I insert a column on the other sheet, (say, Jim) the second table below is what I get, but what I want to occur is...
I don't actually know how to word this question. I'm not looking to simply link cells together with an = or similar function.
Is there a way to set up cells so that if I change the value in any of those cells, they all change? Ideally, they will link across sheets.
Example: A1, B2, and C3 are...
As a basic user, I'm having what I hope is an easy to answer issue, so apologies if it's been asked before.
I have a spreadsheet which records scores for a charity quiz I run twice a year.
The scores are entered into Sheet A (which is organised alphabetically by team name for ease of...
Right now I have a Summary workbook (let's call it [Summary.xlsx]) which has links to about 60 other excel documents (I'll refer to as [Other.xlsx]). I'm trying to pull the last number in a column from the [Other.xlsx] documents into a cell on the summary workbook, but the [Other.xlsx] is...
I want to copy a worksheet to another workbook where everything is linked.
For ex: I have a workbook called "Budget 2016" with a worksheet called "Credit Cards" and a worksheet called "Budget IL & FL". In the "Credit Cards" worksheet I have all info about each credit card like the balance...
I've had a tough time searching for a solution with Google. I don't quite know how else to phrase it.
I have an Excel workbook where users input data. In two of the columns, D and E, users select from in-cell dropdowns (data validation). Each column has three selections to choose...
Is it possible to set a print area in an excel sheet that would hyperlink to a Bluebeam PDF document such that anytime changes were made in the excel those changes would appear in the PDF?
In addition a change to the excel sheet might be a different, usually larger, size of print area. I assume...
I have a sheet that has a list of sheet names that "live" updates, when a new sheet is added or a sheet is moved in the workbook the list updates accordingly to keep the order the sheets are in. However, the column next to that list of names allows the user to place an "x" in cell...
Can anyone please tell me how to do this? Just bear with me until I explain what I need to do. Thanks and... here we go! :)
I have 1 MAIN worksheet that is named TOTALS and 12 secondary worksheets (one for each month of the year) that are called.... January, February, etc.
I need to create a workbook, called “Roundup.xslm,” that links back to cells in the primary workbook, “Articles.xlsm.” Each record (row) has six columns (A:F). One of the columns is hyperlinked to a file or Web URL.
I need to link the rows in Roundup to the records in Articles so that when the...
With Exel 2003:
I want to be able to click on a cell in sheet 1 and get linked directly to a cell with the exact same string in sheet 2. I have just been asked to do this for my boss and I havent...
I want to link 2 cells to each other so that the user can enter a value in either cell, and the value is automatically copied to the other cell via a 2-way dynamic link. Is there any way to set this up without using VBA? I would be surprised if Excel does not have this capability, but...
I want to have a cell that contains a numeric value that's connected somehow to a date. Is there a way to make a cell that contains a value to be "date specific".
Here's what I'm trying to do. I'm making a sheet that is helping me determine inventory quantities at the beginning of each...
I have a spreadsheet in which Worksheet 1 is a master list of names andgroup assignments. Worksheet 2 sorts these names into the respective groups. Worksheets 3 and 4 are group specific worksheets, pulling the sorted group lists from worksheet 2 into column A. Attendance Data for each...
How do i link cells ie if i input somethng into say e5 I want it to add 1 to d5
then if i put info into e6 it will add another 1 to d5 making d5 =2
so E5 =lost18
e6 =won 18
then d5 would =2
e7 =won 9
then d5 would =3
but e5 is on 1 sheet2 and d5 is sheet 2 but in same workbook
I have a master workbook that contains links to a bunch of other workbooks. Primarily, I am just linking to the data themselves, which are numeric. My links currently look like =[source_file.xls]sheetname!A5
I would like to do a few different things here:
1) incorporate replacing in this...
I need some help linking two cells in the same work sheet. I want to be able to click on a cell and it take the viewer to the related cell elsewhere in the spreadsheet... I can do this with a hyperlink but my issue comes when I move the linked cell to a new location. The link then goes...