data manipulation

Dear Friends.

I have a Excel workbook with two sheets. I need a easy program/Formula to transfer the data From the Second Tab sheet (Department Template) to the First Sheet (Cosec Template).

In Department Template:

SL NO EMP-ID NAME 21/12/15 22/12/15 23/12/15 24/12/15 25/12/15 26/12/15
1 270 GANGADHARAPPA GS CL CL GS GH GS
2 276 RAMACHANDRA REDDY GS GS GS GS GH GS
3 274 RAVI K.K NS NS NS NS NS NS
4 1178 ` GS GS GS M1 GH CL
5 2353 SANDEEP KUMAR S3 M1 C/O C/O GH CL

I need a program to take this data aand put it in another sheet called COSEC Template & The desired result should be like as :


UserID Shift ID/Day Marking FROM Date TO Date
270 GS 21/12/2016 21/12/2016
270 CL 22/12/2016 23/12/2016

270 GS 24/12/2016 24/12/2016

270 GH 25/12/2016 26/12/2016
270 W/O 27/12/2016 27/12/2016
270 GS 28/12/2016 02/01/2016

I required the programming to fill up tis data for the particular employee till the end of date 20th (month end)as per sheet2. Then start the next employee starts from 21st to 20th, then next and on until ends. Kindly Note, all in sheet 1 (COSEC Template) should be in Formulas. No manual entries should be there. Need to transfer data from sheet2 to sheet 1 in that format.

Please provide your valuable solutions. Thank u so much for the help in advance.

Regards.
Thilak N

Hi and welcome to the forum

Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Hi... Got the reply from one another excel forum. sharing this for you guys. you can have a look at this.

Please Login or Register  to view this content.

Thanks.
Thilak N

Moderator Note: I have added code tags to your post in accordance with forum rules. Please take the time to read our rules which you agreed to when you joined this forum and comply with them in the future.

You might have a look at:

http://www.excelguru.ca/forums/showt...ll=1#post22389