Hi friends,
I have command button in an excel sheet, for which i have created VBA code. When this button is pressed, it looks for values in Column H and compare it with column B, if these values are found in column B, it will rename a folder in a specific path(path given below) with the values adjacent to it in column A. While renaming the folder it keeps cell E2 value first and then A column value
Path: C:\Users\engr_\Desktop\Test\ (here folders are kept with names of data in column H) screen shots are also given.
Sheet is also attached for reference.
THE ISSUE IS IT ONLY RENAMES WITH THE FIRST DATA OF COLUMN A, IT SHOULD RENAME WITH ADJACENT VALUE ANY NUMBER FOUND. NEED HELP PLEASE
1.PNG
2.PNG
Bookmarks