Hi, I have a VBA code that takes data from file (A) and writes it to an another xls file (B).
I want to create in file B, through VBA, name ranges referring to cell values defined in B- worksheet "Indx" and have them applied to specified ranges in B - worksheet "Data".
The objective is to have the file prepared for a user to enter their updates using just the options specified in the names ranges.
I need somebody to build for me code to be used in file A to accomplish just that.
I have attached a flle B.
Thank you in advance for our kind assistance.
Cheers, N2V Status-File---Example.xls