repetious entries?

W

W E B GU R L

I have one column that has product codes

I have another column where I have to add the same product codes plus a reference to
images that match the product codes

How can I automate this so I do not have to physically type in the path to the images?


e.g

ProductCode - 12345 ----> already in spreadsheet
ImageSmall - ../products/images/12345.jpg ---------> I need to type this


I then convert the spreadsheet to Access.


Thanks for any help!
 
G

Gord Dibben

Assuming Product Codes in column A with Product Code as title.

In B2 enter ="../product/image/" & A2 & ".jpg"

Copy down column B


Gord Dibben Excel MVP
 
W

W E B GU R L

Thanks for the reply

Do I then have to change to this for each line -


In B2 enter ="../product/image/" & A2 & ".jpg"
In B3 enter ="../product/image/" & A3 & ".jpg"

and so on

Will Access recognise A2?




"Gord Dibben" <gorddibbATshawDOTca> wrote in message
Assuming Product Codes in column A with Product Code as title.

In B2 enter ="../product/image/" & A2 & ".jpg"

Copy down column B


Gord Dibben Excel MVP
 
G

Gord Dibben

Just double-click on the fill handle of B2 to copy the formula down column B
as far as you have data in column A.

Fill handle is the small black lump at bottom right corner of the cell.

Or click on the fill handle and drag/copy down column B.

The A2 will change to A3 and A4 etc. as the formula is copied down.

No need to edit each cell.

One other thing......sheepish grin<g>

When you have finished the copy down and looks good........

Select column B and Edit>Copy.

Then Edit>Paste Special(in place)>Values>OK>Esc to get rid of the formulas,
leaving the values only which Acces will recognize.


Gord
 
W

W E B GU R L

Will luv 'ya if this works!

Thanks, will give this a try! The Access NG people have me doing some tricky stuff, this
sounds easier!!



"Gord Dibben" <gorddibbATshawDOTca> wrote in message
Just double-click on the fill handle of B2 to copy the formula down column B
as far as you have data in column A.

Fill handle is the small black lump at bottom right corner of the cell.

Or click on the fill handle and drag/copy down column B.

The A2 will change to A3 and A4 etc. as the formula is copied down.

No need to edit each cell.

One other thing......sheepish grin<g>

When you have finished the copy down and looks good........

Select column B and Edit>Copy.

Then Edit>Paste Special(in place)>Values>OK>Esc to get rid of the formulas,
leaving the values only which Acces will recognize.


Gord
 
W

W E B GU R L

This is great but one thing,


Cannot copy the formula to all fields as you suggested. My first row names each column. I
tried highlighting the entire column but I get an error saying data is not the same size
and shape as that selected and if I say OK, only the first line appears.


Sorry for being so think - you have been so helpful!



"Gord Dibben" <gorddibbATshawDOTca> wrote in message
Just double-click on the fill handle of B2 to copy the formula down column B
as far as you have data in column A.

Fill handle is the small black lump at bottom right corner of the cell.

Or click on the fill handle and drag/copy down column B.

The A2 will change to A3 and A4 etc. as the formula is copied down.

No need to edit each cell.

One other thing......sheepish grin<g>

When you have finished the copy down and looks good........

Select column B and Edit>Copy.

Then Edit>Paste Special(in place)>Values>OK>Esc to get rid of the formulas,
leaving the values only which Acces will recognize.


Gord
 
W

W E B GU R L

I did it!

WOW - Yippeeee!!!!!

:O

This is great but one thing,


Cannot copy the formula to all fields as you suggested. My first row names each column. I
tried highlighting the entire column but I get an error saying data is not the same size
and shape as that selected and if I say OK, only the first line appears.


Sorry for being so think - you have been so helpful!



"Gord Dibben" <gorddibbATshawDOTca> wrote in message
Just double-click on the fill handle of B2 to copy the formula down column B
as far as you have data in column A.

Fill handle is the small black lump at bottom right corner of the cell.

Or click on the fill handle and drag/copy down column B.

The A2 will change to A3 and A4 etc. as the formula is copied down.

No need to edit each cell.

One other thing......sheepish grin<g>

When you have finished the copy down and looks good........

Select column B and Edit>Copy.

Then Edit>Paste Special(in place)>Values>OK>Esc to get rid of the formulas,
leaving the values only which Acces will recognize.


Gord
 
G

Gord Dibben

One down, myriads to go<g>

Gord

I did it!

WOW - Yippeeee!!!!!

:O

This is great but one thing,


Cannot copy the formula to all fields as you suggested. My first row names each column. I
tried highlighting the entire column but I get an error saying data is not the same size
and shape as that selected and if I say OK, only the first line appears.


Sorry for being so think - you have been so helpful!



"Gord Dibben" <gorddibbATshawDOTca> wrote in message
Just double-click on the fill handle of B2 to copy the formula down column B
as far as you have data in column A.

Fill handle is the small black lump at bottom right corner of the cell.

Or click on the fill handle and drag/copy down column B.

The A2 will change to A3 and A4 etc. as the formula is copied down.

No need to edit each cell.

One other thing......sheepish grin<g>

When you have finished the copy down and looks good........

Select column B and Edit>Copy.

Then Edit>Paste Special(in place)>Values>OK>Esc to get rid of the formulas,
leaving the values only which Acces will recognize.


Gord
Click to expand...
 
Top