Master workbook

[Aman Semwal]

The sheet is getting hang after the value are generated is it due to the chart which was deleted ????

 

[Aman Semwal]

Aman Semwal
It took one hour to unlock sheets ... from You?
Do Not Fill Any Cell Below Sheet1's Table! I cleaned those and it works.
Hint! If You work with sheets(2).visible then be sure that it will be always correct sheet!

Have used the same sheet....

 

[vletm]

#26 ... what would You try to write? ... and there is NO CHART!
#27 ... and You didn't do/change anything else like next steps?
1) I open file ...
2) It updated B-column
3) I press [ Get Values ]
4) It (try to) read data from those files
5) ... there comes "Done"
So?

 

[Aman Semwal]

After "done" my file gets hang... it gives me value but my file is totally hanged

 

[vletm]

Upload that file.

 

[Aman Semwal]

Please find the file

 

[vletm]

There are 'some calculations' in Sheet2. ... maybe this?
I disable 'calculation' while use those two 'buttons'.
Test now ...

 

[vletm]

Aman Semwal ... still about those Your calculations ...
You could select 'moments' from Sheet1 (as below) and
next You would press [ Graph ] and
You would get 'Your values as below' ( then no need those heavy calculations. )
Graph will hide/show by [Graph]-btn (or hide by click 'graph')

 

[Aman Semwal]

Aman Semwal ... still about those Your calculations ...
You could select 'moments' from Sheet1 (as below) and
next You would press [ Graph ] and
You would get 'Your values as below' ( then no need those heavy calculations. )
Graph will hide/show by [Graph]-btn (or hide by click 'graph')

View attachment 49528

Hi,

I need help on sheet 3 of this master file with vba. Please help me on this

 

[vletm]

Aman Semwal ... hmm?
I did something like Your 'Sheet3' ...
1) Select needed range as below
2) Press [Values]
3) ... next is like Your PassWord step
4) You would see selected ranges values


[Graph] needs range too which You would like to compare.

ps. I notice that You haven't read some of my replies!
... I modified some of those too!

 

[Aman Semwal]

But how to apply the password in this

 

[Aman Semwal]

But how to apply the password in this

Ya got the password...
But Sheet 3 table do not show correct header of time

 

[Aman Semwal]

Need data as per this sample data

 

[vletm]

Aman Semwal
Small steps ... small steps
... now, comments have 'original values' for reference!

 

[Aman Semwal]

Aman Semwal
Small steps ... small steps
... now, comments have 'original values' for reference!

Still table time header is not as per sheet 1 and Need header for Total and Name

 

[Aman Semwal]

Need data as per this sample data

Need as per this sheet as table

 

[vletm]

Aman Semwal ... hmm?
If You would NEED some FIXED from somewhere values then ... hmm?
But if those values should come from Sheet1 as below too
then I cannot change nothing!

Ex 1st name:
Left side - 'original values': 7 - 13 - 31
Right side - 'hourly values': 7 - (13-7=)6 - (31-13=)18
What would be difference with Your NEEDs to above?
... different colors?

 

[Aman Semwal]

It gives me the hourly count of that person...Where 7 was the total production in 18:00 for Abdul whereas in 19:00 the total production is 13 overall including the 7.
Therefor need data where it only gives the hourly production of that hour

 

[Aman Semwal]

Aman Semwal ... hmm?
If You would NEED some FIXED from somewhere values then ... hmm?
But if those values should come from Sheet1 as below too
then I cannot change nothing!
View attachment 49671
Ex 1st name:
Left side - 'original values': 7 - 13 - 31
Right side - 'hourly values': 7 - (13-7=)6 - (31-13=)18
What would be difference with Your NEEDs to above?
... different colors?

Need data as per screenshot shared by you...

 

[vletm]

It gives me the hourly count of that person...Where 7 was the total production in 18:00 for Abdul whereas in 19:00 the total production is 13 overall including the 7.
Therefor need data where it only gives the hourly production of that hour
Hmm.. You couldn't give even value for that ... is it 6?
or other 'Your NEEDED values'?
2nd Hmm... and next You wrote like below ...
Need data as per screenshot shared by you...
3rd Hmm ... that means ... You couldn't even check that files result ... how?

>>> Basic, NOTHING to change!
This version also 'checks' the 1st values of selected period!

 

[Aman Semwal]

It gives me the hourly count of that person...Where 7 was the total production in 18:00 for Abdul whereas in 19:00 the total production is 13 overall including the 7.
Therefor need data where it only gives the hourly production of that hour
Hmm.. You couldn't give even value for that ... is it 6?
or other 'Your NEEDED values'?
2nd Hmm... and next You wrote like below ...
Need data as per screenshot shared by you...
3rd Hmm ... that means ... You couldn't even check that files result ... how?

>>> Basic, NOTHING to change!
This version also 'checks' the 1st values of selected period!

But why am not able to copy the table of sheet 3

 

[vletm]

But ...
No answers and
not real question ... hmm?
I quickly read previous Replies and
I didn't find any marks of need to copy something from somewhere
... hmm?

 

[Aman Semwal]

But ...
No answers and
not real question ... hmm?
I quickly read previous Replies and
I didn't find any marks of need to copy something from somewhere
... hmm?

Coz I need this data to send in mail to management....
Where in sheet 3 this data I am not able copy this

 

[vletm]

Aman Semwal
No answers ... hmm?
anyway Sheet3 looks like below ...
Which file do You use? and What do You NEED to do?

 

[Aman Semwal]

Just i want to copy the sheet 3 table and paste in the mail where I am unable to copy the table as all the cell are freezed and C5 is only active in sheet3