LinkBack URL
About LinkBacks
Hey guys,
I need some serious help.
I have a whole row full with model numbers, they are all differnet in each line,
i would like to duplicate this row and add ".jpg" at the end of each model number.
Any idea how to do it?
Hey guys,
I need some serious help.
I have a whole row full with model numbers, they are all differnet in each line,
i would like to duplicate this row and add ".jpg" at the end of each model number.
Any idea how to do it?
Last edited by VBA Noob; 12-02-2008 at 05:13 PM.
If your values are in row 2, starting in column B (B2,C2,D2,etc);
In row 3, starting in column B,Drag to the right.
Please Login or Register to view this content.
Then copy and paste special>values to remove the formulas.
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Works like a charm! Thank you so much :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks