repetious entries?

W E B GU R L · 01-25-2005, 06:06 PM

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!

Gord Dibben · 01-25-2005, 08:06 PM

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

On Wed, 26 Jan 2005 08:01:20 +1000, "W E B GU R L" <[email protected]> wrote:

>
>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!
>
>

W E B GU R L · 01-25-2005, 08:06 PM

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
news:[email protected]...
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

On Wed, 26 Jan 2005 08:01:20 +1000, "W E B GU R L" <[email protected]> wrote:

>
>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!
>
>

Gord Dibben · 01-25-2005, 10:06 PM

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

On Wed, 26 Jan 2005 09:52:10 +1000, "W E B GU R L" <[email protected]> wrote:

>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
>news:[email protected]...
>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
>
>
>On Wed, 26 Jan 2005 08:01:20 +1000, "W E B GU R L" <[email protected]> wrote:
>
>>
>>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!
>>
>>
>

W E B GU R L · 01-25-2005, 10:06 PM

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
news:[email protected]...
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

On Wed, 26 Jan 2005 09:52:10 +1000, "W E B GU R L" <[email protected]> wrote:

>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
>news:[email protected]...
>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
>
>
>On Wed, 26 Jan 2005 08:01:20 +1000, "W E B GU R L" <[email protected]> wrote:
>
>>
>>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!
>>
>>
>

W E B GU R L · 01-25-2005, 11:06 PM

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
news:[email protected]...
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

On Wed, 26 Jan 2005 09:52:10 +1000, "W E B GU R L" <[email protected]> wrote:

>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
>news:[email protected]...
>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
>
>
>On Wed, 26 Jan 2005 08:01:20 +1000, "W E B GU R L" <[email protected]> wrote:
>
>>
>>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!
>>
>>
>

W E B GU R L · 01-25-2005, 11:06 PM

I did it!

WOW - Yippeeee!!!!!

:O

"W E B GU R L" <[email protected]> wrote in message
news:[email protected]...
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
news:[email protected]...
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

On Wed, 26 Jan 2005 09:52:10 +1000, "W E B GU R L" <[email protected]> wrote:

>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
>news:[email protected]...
>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
>
>
>On Wed, 26 Jan 2005 08:01:20 +1000, "W E B GU R L" <[email protected]> wrote:
>
>>
>>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!
>>
>>
>

Gord Dibben · 01-26-2005, 01:06 PM

One down, myriads to go<g>

Gord

On Wed, 26 Jan 2005 12:19:20 +1000, "W E B GU R L" <[email protected]> wrote:

>I did it!
>
>WOW - Yippeeee!!!!!
>
>:O
>
>"W E B GU R L" <[email protected]> wrote in message
>news:[email protected]...
>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
>news:[email protected]...
>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
>
>On Wed, 26 Jan 2005 09:52:10 +1000, "W E B GU R L" <[email protected]> wrote:
>
>>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
>>news:[email protected]...
>>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
>>
>>
>>On Wed, 26 Jan 2005 08:01:20 +1000, "W E B GU R L" <[email protected]> wrote:
>>
>>>
>>>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!
>>>
>>>
>>
>
>