I want excel to create a unique identifying number in cell "k1" every time I copy or add a worksheet.
I would prefer it be between 18001 and 18999
I want excel to create a unique identifying number in cell "k1" every time I copy or add a worksheet.
I would prefer it be between 18001 and 18999
Last edited by frankday; 08-06-2018 at 05:06 PM.
Not Understood.
Why not have a userform or input box that runs on double click or if you press ctrl and f?
Please Login or Register to view this content.
Last edited by mehmetcik; 08-06-2018 at 03:01 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
If I have S/N 61413464 on one of the WS in my WB, I want to key in that number someplace and have it go right to that number. It could be on any of 100 WS. I just don't know how to make that happen. I am open to any suggestion.
the post #2 will do that for you. If you are unsure how to use it, then
How to install your new code
- Copy the Excel VBA code
- Select the workbook in which you want to store the Excel VBA code
- Press Alt+F11 to open the Visual Basic Editor
- Choose Insert > Module
- Edit > Paste the macro into the module that appeared
- Close the VBEditor
- Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
To run the Excel VBA code:
- Press Alt-F8 to open the macro list
- Select a macro in the list
- Click the Run button
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Your option above pulls up the find box but then you have to go into options and check "entire workbooK" I was looking for a way that automatically searches the entire workbook. Something more user friendly for my employees.
Please upload a sample workbook with a several sheets and some sample serial numbers. In this manner, we can test code and ensure it works as you have requested. I have looked at the code in Post #2 and it looks like it should work. Seeing a representative sample of your actual workbook will ensure this.
Attached is a sample of what I am working on.
Thanks again for your time.
Duplicate of this thread: https://www.excelforum.com/excel-gen...d-14-14-a.html
Duplicate closed.
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks