Copying data from multiple workbooks [Closed]

Report

Mudhamalle

Posts: 1
Registration date: Wednesday April 5, 2017
Status: Member
Last seen: April 5, 2017

- Updated on Apr 5, 2017 at 11:04 AM

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

Copying data from multiple workbooks
Vba copying data from one workbook to another - How-To - Excel
Copying data from workbook to workbook using button ✓ - Forum - Excel
Excel data validation multiple columns - How-To - Excel
Creating multiple workbooks from a template and a list of names ✓ - Forum - Excel
How to auto populate data from multiple sheets to a master ✓ - Forum - Excel

Copying data from multiple workbooks [Closed]

Your reply

Subscribe To Our Newsletter!