ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Using a cell reference to create linked info in another cell (https://www.excelbanter.com/excel-discussion-misc-queries/178172-using-cell-reference-create-linked-info-another-cell.html)

LCrowe

Using a cell reference to create linked info in another cell
 
OK, I know the title seems confusing, sorry about that. Here is what I am
looking to do. I have a list of stock numbers in column D for example
(10001). In comlumn G, I want to have it auto fill with a file name that has
the stock number in column D with ".jpg" at the end (10001.jpg), any help
would be greatly appreciated


Gary''s Student

Using a cell reference to create linked info in another cell
 
If cell D3 has 10001, then in G3 enter:
=D3 & ".jpg"
--
Gary''s Student - gsnu200771


"LCrowe" wrote:

OK, I know the title seems confusing, sorry about that. Here is what I am
looking to do. I have a list of stock numbers in column D for example
(10001). In comlumn G, I want to have it auto fill with a file name that has
the stock number in column D with ".jpg" at the end (10001.jpg), any help
would be greatly appreciated


LCrowe

Using a cell reference to create linked info in another cell
 
Thank you!!!! I'll probably ave some more stuff to inquire about at another
time.

"Gary''s Student" wrote:

If cell D3 has 10001, then in G3 enter:
=D3 & ".jpg"
--
Gary''s Student - gsnu200771


"LCrowe" wrote:

OK, I know the title seems confusing, sorry about that. Here is what I am
looking to do. I have a list of stock numbers in column D for example
(10001). In comlumn G, I want to have it auto fill with a file name that has
the stock number in column D with ".jpg" at the end (10001.jpg), any help
would be greatly appreciated



All times are GMT +1. The time now is 06:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com