Dear all,
Greetings of the day..!!!
I m looking for a macro for the below requirement.
There are multiple workbooks in a Folder, all workbooks have multiple worksheets which contains data.
for example
In 1st worksheet (EMP Information)
EMPLOYEE NAME : XXX GRADE: XXX
EMPLOYEE NO: XXXX DESIGNATION: XXX
LOCATION: XXX DOJ(DD/MM/YYYY): XXX
DEPARTMENT: XXX FOR THE PERIOD: XXX
MANAGER'S NAME: XXX
In 2 worksheet (Goals Review)
need to pull the data from the cell J16 to J31
All the Data should be in this COLUMN wise format
EMPLOYEE NAME EMPLOYEE NO DEPARTMENT MANAGER NAME ..............
XXXX XXXX XXXX XXXX ........
YYYY YYYY YYYY YYYY........
Please help me out with macro
Thanks in Advance.
-Anvesh