Computer Hope
Software => Computer software => Topic started by: Nelsondavid on December 01, 2016, 09:10:14 AM
-
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]
-
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?
-
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
-
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?
-
thats right it is not sorted
-
In file2 what you see is 21 oct to nov 20 one month , marked green are sundays
-
A reference: Sort data in a range or table (https://support.office.com/en-us/article/Sort-data-in-a-range-or-table-62d0b95d-2a90-4610-a6ae-2e545c4a4654)
-
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
-
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
-
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!?
-
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
-
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.
-
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
-
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
-
Any reason you're quoting your own Post ? ?
-
reason for that was wrong link pasted 2nd link , it is correctly pasted , mistake made was instead of reply i clicked quote....sorry
-
Updated links
https://www.dropbox.com/s/vgor9ihdzrdgy45/FILE%201.xlsx?dl=0
https://www.dropbox.com/s/ymf8041y66zn36e/FILE2.xlsx?dl=0