1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Master workbook

Discussion in 'VBA Macros' started by Aman Semwal, Jan 27, 2018.

  1. Aman Semwal

    Aman Semwal Member

    Messages:
    45
    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.
  2. Niraj Baraili

    Niraj Baraili Member

    Messages:
    95
    Can you at least share some dummy data for input and how your output look like ?
  3. Aman Semwal

    Aman Semwal Member

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

    Attached Files:

  4. Aman Semwal

    Aman Semwal Member

    Messages:
    45
    Can anybody help on this scenario....
  5. vletm

    vletm Excel Ninja

    Messages:
    3,677
    Aman Semwal
    ... are You busy?
    Write number to cell [F2] and press <ENTER> ..

    Attached Files:

  6. Aman Semwal

    Aman Semwal Member

    Messages:
    45
    Thanks a lot it works fine...:)
  7. Aman Semwal

    Aman Semwal Member

    Messages:
    45
    Hi,
    Just to ask a question is it possible to make hourly production count from output workbook...
  8. vletm

    vletm Excel Ninja

    Messages:
    3,677
  9. Aman Semwal

    Aman Semwal Member

    Messages:
    45
    Please send me the sample
  10. vletm

    vletm Excel Ninja

    Messages:
    3,677
    Where are Your hourly values?
    from 0 to 23?
  11. Aman Semwal

    Aman Semwal Member

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

    Attached Files:

  12. vletm

    vletm Excel Ninja

    Messages:
    3,677
    As written:
    Where are Your hourly values?
    You show 'output' ... where is 'input'?
  13. Aman Semwal

    Aman Semwal Member

    Messages:
    45
    Please find the reference

    Attached Files:

  14. vletm

    vletm Excel Ninja

    Messages:
    3,677
    Aman Semwal ... hmm?
    ... or something like this:
    1) Write Your 'date & time's as below
    Screen Shot 2018-01-28 at 11.17.07.png
    2) Select wanted 'date & time'
    3) Press the button
    >> You will see that dates that moments values <<

    Attached Files:

    Chirag R Raval likes this.
  15. Aman Semwal

    Aman Semwal Member

    Messages:
    45
    Thanks a lot it helped me \..
  16. vletm

    vletm Excel Ninja

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

    Attached Files:

    Chirag R Raval likes this.
  17. Aman Semwal

    Aman Semwal Member

    Messages:
    45
    Thanks for the sample it really helped me.

    U r genius..:)
  18. Aman Semwal

    Aman Semwal Member

    Messages:
    45
    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

    Attached Files:

  19. vletm

    vletm Excel Ninja

    Messages:
    3,677
    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! <<
  20. Aman Semwal

    Aman Semwal Member

    Messages:
    45
    To open vba code pswrd is 8510950598
    Should I keep the chart ?
    Please help me on this
  21. vletm

    vletm Excel Ninja

    Messages:
    3,677
    As I wrote - NOT CORRECT!
    Screen Shot 2018-02-01 at 23.11.21.png
    If You change 'wrong thing' ... maybe challenge!
  22. vletm

    vletm Excel Ninja

    Messages:
    3,677
    ... and You have changed some settings too.
  23. vletm

    vletm Excel Ninja

    Messages:
    3,677
    ... 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.
  24. Aman Semwal

    Aman Semwal Member

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

    Attached Files:

  25. vletm

    vletm Excel Ninja

    Messages:
    3,677
    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!

    Attached Files:

Share This Page