Master workbook

[Aman Semwal]

Hi,

Please help me to automate my data with vba with below scenario:
1. I have multiple workbook consist of my teammate names such as Aman.xlsx,Amit.xlsx,etc.
2 Taking one of the workbook and what does is consist of is that it has 31 sheet in each of the workbook based on date of the month.
3. In this worksheet there is the number of production done by them each day such as sheet name 1 consist of 35 claims and so on in 2,3,4,etc
4.This multiple workbook are in same folder.
5.I have a master workbook with name of my teammate in sheet 1
6. In which I have three headers Name,Target,No of production achieved.
7.Please provide a code which automate all day wise data of my teammate.

Note : Workbook cannot be shared as per company policy.

Waiting for this.

 

[Niraj Baraili]

Can you at least share some dummy data for input and how your output look like ?

 

[Aman Semwal]

Please find a dummy data of master workbook and a workbook from where it takes data.

 

[Aman Semwal]

Can anybody help on this scenario....

 

[vletm]

Aman Semwal
... are You busy?
Write number to cell [F2] and press <ENTER> ..

 

[Aman Semwal]

Thanks a lot it works fine...

 

[Aman Semwal]

Hi,
Just to ask a question is it possible to make hourly production count from output workbook...

 

[vletm]

Yes.

 

[Aman Semwal]

Please send me the sample

 

[vletm]

Where are Your hourly values?
from 0 to 23?

 

[Aman Semwal]

For more reference please check the master file what I want to get as answer.

 

[vletm]

As written:
Where are Your hourly values?
You show 'output' ... where is 'input'?

 

[Aman Semwal]

Please find the reference

 

[vletm]

Aman Semwal ... hmm?
... or something like this:
1) Write Your 'date & time's as below

2) Select wanted 'date & time'
3) Press the button
>> You will see that dates that moments values <<

 

[Aman Semwal]

Thanks a lot it helped me \..

 

[vletm]

Aman Semwal
... and if You would like to get those data & times to add 'automatic' then test this.

 

[Aman Semwal]

Aman Semwal
... and if You would like to get those data & times to add 'automatic' then test this.

Thanks for the sample it really helped me.

U r genius..

 

[Aman Semwal]

Hi,
When I used the last format of master file it gets hang after giving the value.
Total people workbook is 66 and it takes long time

 

[vletm]

Aman Semwal
1) You have changed ... at least deleted that chart away
2) That O3-cell do not work = wrong! >> I cannot check code!
3) Original file works!
>> I cannot help with this file! <<

 

[Aman Semwal]

To open vba code pswrd is 8510950598
Should I keep the chart ?
Please help me on this

 

[vletm]

As I wrote - NOT CORRECT!

If You change 'wrong thing' ... maybe challenge!

 

[vletm]

... and You have changed some settings too.

 

[vletm]

... and ...
I tested to run [ Get Values ] from ORIGINAL-code ... seems to work!
There are 68 names .. and even one gave answer too!
[ Add Times ] won't work correct with Your settings/modifications.

 

[Aman Semwal]

Have unlocked the sheet. Please help now as the sheet getting hanged after the macro runs and excel doesnt respond totally.

 

[vletm]

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!