Howdy!
I have a workbook, which will have many identical worksheets. Say my first worksheet (tab) is titled 0001, and the document is also number 0001 (cell J2), how can I have both the tab name and cell J2 update together, upon copying tab 0001, to number 0002?
Thank you in advance, help is appreciated!
Shawna
Last edited by shawnashawna; 07-11-2013 at 11:10 AM.
Hi, sounds like a simple macro but, if you post an example of results expected then it would be easier to know exactly what you are after
I feel so foolish, but I can't figure out how to attach an example??
The FAQ said to find the "browse" button, and attach my file from there, but I am not seeing a browse option?
Update Tab only when cell value change. VBA code
Update Cell only when tab value change.
ActiveSheet.Name = Range("A2").Value
=REPLACE(CELL("filename",A1),1,FIND("]",CELL("filename",A1)),"")
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
Oh, I got it..... wenqq3, your second option is great. Thank you both, very much!!
Your are welcome. Thanks for feedback.
FYI
Post a WORKBOOK.
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), (Add Files) browse to the required file, and then push the Upload button.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks