Moving rows with Date field from one worksheet to another

[Nelsondavid]

Hello,

Have a Excel file with multiple sheets , each sheet is identified by the persons ID number
See attached file.Here i need to copy data from FILE1 in each sheet to FILE2

As you see in file1 that data for each person is scar tared , that is date are up and down ...that data need to be moved to file2 where already date from 21 oct to 20 nov is marked.


THANKS

[attachment deleted by admin to conserve space]

[soybean]

i need to copy data from FILE1 in each sheet to FILE2

I'm wondering about the wording of the quoted part of your post.  I suspect it would be better worded like this: i need to copy data from each sheet in FILE1 in to corresponding sheets in FILE2.   Is that correct?  Are FILE1 and FILE2 names of separate Excel files?

[Nelsondavid]

yes i need to copy data from each sheet in FILE1 in to corresponding sheets in FILE2.

The thing to take care here is in file1 data is scattered , that data need to be put in order as per the date in file2 . Yes file1 and file2 are separate files 

[soybean]

Can you elaborate on how the data in File1 is scattered?  Do you mean unsorted?  Is that what you're trying to convey by highlighting in green some dates in File2?

[Nelsondavid]

thats right it is not sorted

[Nelsondavid]

In file2 what you see is 21 oct to nov 20 one month , marked green are sundays

[soybean]

A reference: Sort data in a range or table

[Nelsondavid]

it is not plain sorting only with reference to date , the row with a particular date in each sheet should move to the same date in file2

[Nelsondavid]

here what am looking for is a sort of macro which can be used to move the data from file1 to file2 .

just for example have shown 3 sheets in both files , in actual we need to deal with 600 to 700 sheets in each file

[soybean]

What is the purpose copying the data from one Excel file to another?  Is this just for sorting, in File2, the same data that is in File!? 

[Nelsondavid]

File1 is timesheets of each employee , there may be days when the employee is absent and no entry of that day available in file1.when we move data from file 1 to file 2 , the days employee is absent , only date should be there in that row

[soybean]

Well, you have a complicated situation regarding all that data and I don't think I can take the time to delve into it further with you.  Engaging a discussion in a forum devoted to Excel might be a good way to proceed.  You could try http://www.excelforum.com/ or search on excel forum for others.

[Nelsondavid]

Link to see demo files , file1 and file 2 link

In file2 i manually entered the data , in the same way i need data from file1 to be copied to file2 in all sheets

https://www.dropbox.com/s/7jq9gxuxuimtlgu/FILE1.docx?dl=0

https://www.dropbox.com/s/hc1stm1llbsahh9/FILE%201.xlsx?dl=0

[Nelsondavid]

Link to see demo files , file1 and file 2 link

In file2 i manually entered the data , in the same way i need data from file1 to be copied to file2 in all sheets

https://www.dropbox.com/s/7jq9gxuxuimtlgu/FILE1.docx?dl=0

https://www.dropbox.com/s/ymf8041y66zn36e/FILE2.xlsx?dl=0

[patio]

Any reason you're quoting your own Post ? ?

[Nelsondavid]

reason for that was wrong link pasted 2nd link , it is correctly pasted , mistake made was instead of reply i clicked quote....sorry

[Nelsondavid]

Updated links

https://www.dropbox.com/s/vgor9ihdzrdgy45/FILE%201.xlsx?dl=0

https://www.dropbox.com/s/ymf8041y66zn36e/FILE2.xlsx?dl=0