+ Reply to Thread
Results 1 to 4 of 4

Need www.mywebsite.com/001.jpg to copy down.

  1. #1
    Forum Contributor
    Join Date
    06-24-2013
    Location
    United Kingdom
    MS-Off Ver
    Office 365
    Posts
    114

    Need www.mywebsite.com/001.jpg to copy down.

    Need to populate down the cells

    www.mywebsite.com/images/002.jpg
    www.mywebsite.com/images/003.jpg
    www.mywebsite.com/images/004.jpg
    www.mywebsite.com/images/005.jpg
    www.mywebsite.com/images/006.jpg
    Last edited by king10001; 08-29-2013 at 07:26 AM.

  2. #2
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Need www.mywebsite.com/001.jpg to copy down.

    Try this..

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

  3. #3
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Need www.mywebsite.com/001.jpg to copy down.

    In first cell

    ="www.mywebsite.com/"&TEXT(ROW(A1),"000")&".jpg "

    Copy down
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  4. #4
    Forum Contributor
    Join Date
    06-24-2013
    Location
    United Kingdom
    MS-Off Ver
    Office 365
    Posts
    114

    Re: [SOLVED]Need www.mywebsite.com/001.jpg to copy down.

    As you guys are here maybe you know.

    Can you populate a cell that has html in from another cell.

    IE

    <title> Cell A1 </title> where A1 in say Apple Iphone so it reads <title> Apple Iphone </title>

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to copy cell width to new sheets (ie copy original sheet format)
    By teenyjem in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-20-2013, 07:28 AM
  2. Save copy as, open copy, alter copy, save copy and close copy
    By tradinup2 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-03-2013, 04:42 PM
  3. Macro to copy Dyanmic lists then copy sheet and clear the original data
    By twiggywales in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-30-2012, 01:06 PM
  4. Copy one cell to an other but colors do not copy. While not using clipboard to copy.
    By chuckchuckit in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-19-2010, 03:08 AM
  5. EXCEL FILE a copy/a copy/a copy ....filename
    By ve in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 09-29-2005, 05:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1