Is there any faster way inorder to name all of the nameboxes?
A2-D2 = Question1
A3-D3 = Question2
and so on and so forth, because i got around 2500+ questions.
1_zpsprf9nykp.png
Is there any faster way inorder to name all of the nameboxes?
A2-D2 = Question1
A3-D3 = Question2
and so on and so forth, because i got around 2500+ questions.
1_zpsprf9nykp.png
You could select the range A2:D2500 and then in the immediate window enter this command. Change range selected to suit your data
from workbook ALT+F11 to open vbeindex=1:for each xrow in selection.rows:activeworkbook.Names.Add name:="Question" & index,referstor1c1:="='" & xrow.parent.name & "'!" & xrow.address(true,true,xlR1C1):index=index+1:next xrow
CTRL+G to open immediate window.
paste code and with the cursor on the line with code press enter.
What if this one sir?
In data validation:
Dead-Reckoning is sourced on = Question1
What about the estimated position, how can i automatically source it to Question2? So on and so forth, cuz i got around 2500+ questions sir. Thanks
1_zpsk92jjppj.png
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks