Junk

Ask something
Question Locked

Master Sheet

0 helpful
3 replies

by ronsiela

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I must have put in data the wrong way..
Excel sheet with a cell to be filled in from sheet two, hyperlinked with names... when I hit the hyperlink I would like the name to fill in the master on sheet one. this is a one position cell only
Sheet one cell a1 = hyperlink name on sheet two, what is this formula ....

Sheet Two
a1- bob
b1 - nancy
c1 tom when I clink on this names they do go th the right cell but can not find information to update master cell location

3 replies

by computercookie

Do mean Value of a cell in sheet 1 is equal to a value in a corresponding cell in sheet 2?

Try "=sheet2!A1

by seanferd

https://www.techrepublic.com.com/5208-6230-0.html?forumID=101&threadID=251553

But we can take it from here on this thread now.

For the previous setup we discussed, you don't need to click on anything. The cell input is automatically linked.
_______________________________

Referring to the previous suggestion
=(Sheet2!A1)
enter the formula for each cell you want data to appear in. Replace A1 with the cell name the data is coming from.
_______________________________

If this isn't what you are looking for, please expand on your concept, giving us a complete example, clearly worded. The folks here can help you, but we need more info on what exactly it is you are trying to do.

This discussion is closed to new replies.