Looping through worksheet and append data from one column to another

[dgulliver]

Hi,

I have a worksheet which I need to beable to loop through the work sheet and append the product name to the end of the path.

for example here is a simple worksheet

Product Name	Path
dsc_0004.JPG	folder1/folder2/folder3/
dsc_0005.JPG	folder1/folder2/folder3
dsc_0006.JPG	folder1/folder2/folder3/
dsc_0007.JPG	folder1/folder2/folder3/
dsc_0008.JPG	folder1/folder2/folder3/
dsc_0009.JPG	folder1/folder2/folder3/

Any help would be great.

Thanks
Darren

[arlu1201]

If your data starts in row2, try this in C2

Please Login or Register  to view this content.

Also you will need to change the / to \ in the path column.

[dgulliver]

Thanks Arlette,

Is there no way to achieve this without using formulas? The spreadsheet is going to be used as a CSV to import in to my website. The script expects the exact number columns and cannot skip columns.

Thanks
Darren

P.S The / is correct as this is going to be imported to my website

[tangangtanga]

@ts kindly check this macro please put a command button and assign this macro to that command button. if this helps please inform me thank you.

Please Login or Register  to view this content.

here's another one.

Please Login or Register  to view this content.