import datas from one excel to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is Krishnakanth. For example. I am having an excel named book1. Under
the book1, I am having 3 worksheets sheet1, sheet2 and sheet3. The sheet1
consists of the details of employee1. sheet2 consists of the details of
employee2 and similarly sheet3 consists of the details of emplyee3.

In the sheet1, in the cell B2, there is a text called(field) Name, in the
cell B3, there is a text called(field) Ecode, in the cell B4, there is a text
called(field) Salary. Then in the cell C2, C3 and C4 consists of Sandra,
AJ00112 and 10000 respectively.

Similarly the sheet2 consists of the details for another employee.(C2,C3,C4
- Daniel, AJ00110 and 12000). Likewise I am details for 100 employees

Now I want a new worksheet in a new excel (book2/sheet1), where the cells
B3, C3, D3 consists of Name, Ecode and Salary. The name of the employee,
ecode of the employee and salary of the employee should be followed in the
cells B4,C4 and D4. Likewise this is to be extended till 100 employees.
____________________________________________
A B C D E
1
2
3 NAME ECODE SALARY
4 SANDRA AJ00112 10000
5 DANIEL AJ00110 12000
_____________________________________________

What can be done to achieve this task.
Can anyone from Microsoft Office - Excel discussion groups help me ?

Krishnakanth VM
Software Engineer
 
In B4 enter: =INDIRECT("[FirstBook.xls]Sheet"&ROW(A1)&"!C"&COLUMN(C1))
and copy across to column D and then copy the three formulas down as far as
needed

I used a book called "FirstBook"; you can change this to what ever name you
workbook is called.
Bit if it has spaces in the name you need
=INDIRECT("'[First Book.xls]Sheet"&ROW(A1)&"'!C"&COLUMN(C1))
where we have a double quote " followed by a single quote ' before [ and
before !

Note that FirstBook must be open
best wishes
 
Back
Top