For a massive range of data, I need to change the drop-down formula from a direct call as it is now (something like "=OptionList") to an indirect call (something like "=Indirect(A4)". BUT, the hard part is that I am doing this for a few thousand cells in multiple columns, so I want to somehow keep all of the correct contents that are already there, while still changing the method in which the drop-downs will be called in the future. Is this possible?
HI Sharkham,
welcome to the forum.
And is there any logic (criteria) using which we can tell Excel that these are correct contents ? thanks.so I want to somehow keep all of the correct contents that are already there, while still changing the method in which the drop-downs will be called in the future.
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks