[Help] Auto Numbering in a column
Hi Guys!
kindly help me
I want to do auto increase in number in a link.
for example
C:\\Users\\R\\Documents\\Share\\twitter\\1.jpg
the next should be
C:\\Users\\R\\Documents\\Share\\twitter\\2.jpg
Next
C:\\Users\\R\\Documents\\Share\\twitter\\3.jpg
and so on. How can I achieve this.
Your image links are dead. Please attach a sample workbook instead of images.
Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
I haven't attach any image file. just posted a query
In A1 copied down:
="C:\\Users\\R\\Documents\\Share\\twitter\\"&ROWS(A$1:A1)&".jpg"
Last edited by AliGW; 08-11-2017 at 12:23 PM.
Great! it works. Thanks a lotOriginally Posted by AliGW
Oh, I'm sorry!!! I thought you were trying to show us images. OK - understood.
And for a clickable hyperlink:
=HYPERLINK("C:\\Users\\R\\Documents\\Share\\twitter\\"&ROWS(A$1:A1)&".jpg")
You're welcome!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks