repetious entries?

  • Thread starter Thread starter W E B GU R L
  • Start date Start date
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!
 
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
 
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
 
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
 
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
 
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
 
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
 
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...
 
Back
Top