| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keeping cell info intact when sorting worksheets w/some linked cel | Setting up and Configuration of Excel | |||
| Linked value to cell in different workbook + Relative File Reference | Excel Discussion (Misc queries) | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
| Dynamically-linked formula, cell reference in the string | Excel Worksheet Functions | |||
| can i create multiple columns from the info in one cell | Excel Discussion (Misc queries) | |||
Linear Mode
