rider@1234
Banned
- Joined
- Jun 20, 2019
- Messages
- 4
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2013
[FONT="]all files are located in desktop[/FONT]
[FONT="]vba is placed in seperate file[/FONT]
[FONT="]only 1 file is opened and that is vba code placed file so for this process we have to open the file as per condition and after the process completed all files should be saved and closed except vba placed file[/FONT]
[FONT="]If column R of 1.xls file is not in minus(-1,-0.5 or xyz any negative number) then see the column E data of 1.xls and open 2.xlsx and match column E of 1.xls with column A of 2.xlsx [/FONT]
[FONT="]and if it matches then look for any highlighted colour in that row and if any highlighted cell in that row is found then remove the highlighted colour and save the file and close all the file[/FONT]
[FONT="]So plz have a look and do needful[/FONT]
[FONT="]vba is placed in seperate file[/FONT]
[FONT="]only 1 file is opened and that is vba code placed file so for this process we have to open the file as per condition and after the process completed all files should be saved and closed except vba placed file[/FONT]
[FONT="]If column R of 1.xls file is not in minus(-1,-0.5 or xyz any negative number) then see the column E data of 1.xls and open 2.xlsx and match column E of 1.xls with column A of 2.xlsx [/FONT]
[FONT="]and if it matches then look for any highlighted colour in that row and if any highlighted cell in that row is found then remove the highlighted colour and save the file and close all the file[/FONT]
[FONT="]So plz have a look and do needful[/FONT]