![]() |
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 |
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 |
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