Re: $$Excel-Macros$$ Develop a macros for a problem

2016-02-05 Thread Saurabh Karangutkar
On Friday, February 5, 2016 at 6:54:21 PM UTC+5:30, Saurabh Karangutkar wrote: > > HELLO PAUL YOU HAVE BEEN A GREAT HELP . BUT I M JUST A AMATEUR IN MACROS > SO CAN YOU DO THE NECESSARY CHANGES AND SEND ME THE UPDATED TOOL . I HAVE > UNPROTECTED THE SHEET SO YOU CAN MAKE THE NECESARY CHANGES

Re: $$Excel-Macros$$ Develop a macros for a problem

2016-02-05 Thread Saurabh Karangutkar
HELLO PAUL YOU HAVE BEEN A GREAT HELP . BUT I M JUST A AMATEUR IN MACROS SO CAN YOU DO THE NECESSARY CHANGES AND SEND ME THE UPDATED TOOL . I HAVE UNPROTECTED THE SHEET SO YOU CAN MAKE THE NECESARY CHANGES .. On Friday, February 5, 2016 at 6:38:13 PM UTC+5:30, Paul Schreiner wrote: > > OK, ini

Re: $$Excel-Macros$$ Develop a macros for a problem

2016-02-05 Thread Paul Schreiner
OK, initially:- The "Main" sheet is protected (luckily, without a password).  The protection does not allow locked cells to be selected.  The sheet was  protected with the a locked cell selected.  Therefore, when the macro tries to select the sheet "Main", an error occurs.Solution:  Unprotect the

$$Excel-Macros$$ Develop a macros for a problem

2016-02-04 Thread Saurabh Karangutkar
The name of the software is price mapping tool . Here it is what it is intented to do . Here is the problem Sheet 1 - file 1 is base datafile thats maps our master product file with master product file received from our suppliers / merchants listing supplier product code to our product code,