Hello,
I need to change the name of Cell A1 on worksheets 1 thru 65. I have a worksheet named "MasterList" that I will be using VLOOKUP formula (=VLOOKUP($A$1,MasterList!$A$1:$B$65,2,0))to populate Cell B1 in each worksheet but need to change Cell A1 in each worksheet from "Name:" to "Name1", "Name2", "Name3", etc. Is there a way to change the names at one time? I've attached a dummy spreadsheet of what I am working on. Thanks.
Last edited by onlyonekj; 06-07-2017 at 05:02 PM.
change ИМЯ ФАЙЛА to FILENAME
remove spaces in sheetnames
="Name"&MID(CELL("ИМЯ ФАЙЛА",A1),SEARCH("]",CELL("ИМЯ ФАЙЛА",A1))+1,255)
you have Name 15, should be Name15
Hi Tim,
Thank you for your response. I have never seen "ИМЯ ФАЙЛА" before...I am not sure I even know what it means. Can you tell me what it is or says and did you change your keyboard or used the symbols to insert those letters? Thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks