Excel spreadsheet
I need a way to display 3 cells of data.
for instance
Cell 1 Cell 2 Cell 3 20 140 Lee 12 110 Kerrie
Whenever any name is entered in cell 3, I need a separate spreadsheet to display the name (cell 3) and the information in cells 1 and 2 (the information in cells 1 and 2 will always be different).
It is not clear from your question whether you are talking about entering a person's name in one cell (for example, "C3") or somewhere in this column (for example, "C: C").
In the first case, you can easily use the Guiness clause; or you can more easily write a formula like this to concatenate the values in cells 1 through 3 (assume the worksheet is named "Sheet1"):
="Name = "&Sheet1!C3&": Cell1 = "&Sheet1!A3&", Cell2 = "&Sheet1!B3
(This is based on cells 1 through 3 in your example, which are in columns A through C and in row 3.)
On the other hand, if you are talking about the latter case and you want to run some VBA code whenever a new name is added to column C, you can use the VBA Worksheet_Change function. If so, edit the question to indicate it.
a source to share
-
Say you have an Excel 1 workbook called Book1.xls. Open this book and enter the following in the first three lines and in the first three columns
Line 1 - cell1 cell2 cell3
Line 2 - 20 12 Jee
Row 3 - 87 25 Kee -
Now open another book - let's say Book2.xls. Select the cell where you want to place the value. In this cell press "=" (equal sign)
-
Now this is the important bit. After clicking equals, go back to the first Excel workbook and select the cell whose contents you want to enter into the second workbook.
So, in this case, the cell in the second workbook will have a formula like this. = [Book1] Sheet1! $ A $ 2
Do the same for the rest of the cells you want.
Important: Please note that the second book will not be full unless the first book is also opened.
a source to share