Excel List Of Data Transfer To Another Sheet Based On The Date

[binoyfalcon]

Dear Expert Helpers,

Please help me for transfer sheet AUG datewise entry to sheet AUGUST.


Thank you

 

[vletm]

binoyfalcon​

There were few challenges with Your case.
Your 'DATE's are text
... those can change to dates.
Your AUGUST-sheet misses sample of expected output
... I offer something to AUG-sheet ( K, L & M -columns )

 

[binoyfalcon]

Dear vletm,

PLease find attached sheet. I want to transfer the datas from the named sheets to AUGUST master sheet.

Thank you

 

[vletm]

binoyfalcon​

Now Your AUGUT-sheet has ... four names and each name row has ... 16 cells with color.
Your 'DATE's are still texts in those four other sheets.
Why do You want that names are in rows and 'date's are in columns?

 

[binoyfalcon]

binoyfalcon​

Now Your AUGUT-sheet has ... four names and each name row has ... 16 cells with color.
Your 'DATE's are still texts in those four other sheets.
Why do You want that names are in rows and 'date's are in columns?

I CHANGED THE FORMAT TEXT TO DATE, AND THE COLOUR .
I need the master In & Out report for each employees in a month

 

[binoyfalcon]

binoyfalcon​

Now Your AUGUT-sheet has ... four names and each name row has ... 16 cells with color.
Your 'DATE's are still texts in those four other sheets.
Why do You want that names are in rows and 'date's are in columns?

Why do You want that names are in rows and 'date's are in columns?

im fine with it either way

 

[vletm]

binoyfalcon​

Your 'DATE's are still texts ... I can take care those.
There are other kind of challenges with Your 'TIME' ... solved too.
Your data sheets has different layouts
... IMRAN & PAUL has valid layouts
... You've to modify other layout Yourself as those (or You'll see red-tabs).
You can add there as many 'data'-sheets as You'll need (with valid layout)
I did one sample with 'my way'.
> Press [ ReFresh ] -button in Output-sheet ... and wait.
>> You'll see whole data <<

 

[yadav59q]

Thank you for share with us.

 

[binoyfalcon]

binoyfalcon​

Your 'DATE's are still texts ... I can take care those.
There are other kind of challenges with Your 'TIME' ... solved too.
Your data sheets has different layouts
... IMRAN & PAUL has valid layouts
... You've to modify other layout Yourself as those (or You'll see red-tabs).
You can add there as many 'data'-sheets as You'll need (with valid layout)
I did one sample with 'my way'.
> Press [ ReFresh ] -button in Output-sheet ... and wait.
>> You'll see whole data <<

Dear vletm,

Thank you very much for your kind support. Its work perfectly.

can i get the output data with monthly wise selection..

 

[vletm]

binoyfalcon​

... hmm?
You can eg filter that output-sheet as You want.
... or what do You have in Your mind?

 

[binoyfalcon]

binoyfalcon​

... hmm?
You can eg filter that output-sheet as You want.
... or what do You have in Your mind?

I tried to filter the data but its not filter properly , enter the start date and end date, output generate between the start and end date

 

[vletm]

binoyfalcon​

I tried this 'my way' ... and it seems to work other way.
... Could You test it 'these ways'?
#1 Select any 1st day of Month and click the button above Date-text >> Button tries to show [ Month-Year ]
#2 Select any other than 1st day of Month and click the button above Date-text >> Button tires to show [ Week-Year ]
You could see sums of Week/Month right side of OUT-texts.
Ps. Every 2nd click to that Button 'resets' Output-sheet

 

[binoyfalcon]

binoyfalcon​

I tried this 'my way' ... and it seems to work other way.
... Could You test it 'these ways'?
#1 Select any 1st day of Month and click the button above Date-text >> Button tries to show [ Month-Year ]
#2 Select any other than 1st day of Month and click the button above Date-text >> Button tires to show [ Week-Year ]
You could see sums of Week/Month right side of OUT-texts.
Ps. Every 2nd click to that Button 'resets' Output-sheet

DEAR VLETM.....

THANK YOU VERY MUCH....