copy contents from one excel file to another excel file

[vishalvijayan]

Hello,

I have two excel file A and B. I want to copy the contents of excel file B to excel file A.

The format of excel file A is as below

A	B	C	D
		1/7	2/7
		Sun	Mon
Emp Name
	In
	Out
	SS
	Late/Early
	W.H.

<TBODY>
</TBODY>

The format of the table in excel file B is as follows -

A	B	C	D	E	F	G	H
Emp No.	Emp Name	Shift	In	Out	Late	Work Hour	Remark

<TBODY>
</TBODY>

Now daily I retrieve report from attendance software in the excel file B format. I want to know how can I copy the contents of excel file B to the format in excel file A.


For example - , excel file B-cell C2 --->excel file A - cell C6,
excel file B-cell D2 --->excel file A - cell C4,
excel file B-cell E2 --->excel file A - cell C5,
excel file B-cell F2 --->excel file A - cell C7,
excel file B-cell G2 --->excel file A - cell C8,
excel file B-cell H2 --->excel file A - cell C3,

This should be as per the date, as I take report on daily basis.
Please guide me on how do the above.

Thank you
Vishal

 

[Michael M]

Please keep to the original thread...
http://www.mrexcel.com/forum/showth...nts-from-one-excel-file-to-another-excel-file

 

[VoG]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).