Dbennett4995
New Member
- Joined
- Dec 1, 2009
- Messages
- 2
What I am wanting is for when specific data is entered into Excel, lets say
'A-1', then I would want that data to be matched against an Access table which would then pull the aligning data and place it in 'B-1'. My situation is that I am importing products into our company's website. We already have a industry-wide database which has each manufacturer's products, model numbers, image names, etc. When filling up my excel import product sheet I would want the model number that I paste into Column 'A' automatically reciprocate the specific name call for that product's image. So as an example:
Model size image
A B C
1 kSS80 kSS080.jpg
input output
my spaces weren't taking above in my example. Column A , row 1 would be the model being input and the output would be displayed in column B in the row equivalent to the data being input.
How could I accomplish this? Any advice is greatly appreciated.
'A-1', then I would want that data to be matched against an Access table which would then pull the aligning data and place it in 'B-1'. My situation is that I am importing products into our company's website. We already have a industry-wide database which has each manufacturer's products, model numbers, image names, etc. When filling up my excel import product sheet I would want the model number that I paste into Column 'A' automatically reciprocate the specific name call for that product's image. So as an example:
Model size image
A B C
1 kSS80 kSS080.jpg
input output
my spaces weren't taking above in my example. Column A , row 1 would be the model being input and the output would be displayed in column B in the row equivalent to the data being input.
How could I accomplish this? Any advice is greatly appreciated.
Last edited: