+ Reply to Thread
Page 7 of 7 FirstFirst ... 5 6 7
Results 91 to 99 of 99

Consolidate workbooks

  1. #91
    Forum Contributor
    Join Date
    07-31-2008
    Location
    UK
    Posts
    104

    Re: Consolidate workbooks

    Hi John, all A OK

    I have even added some msgbox loops too, to make the users confirm.

  2. #92
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2007 2003
    Posts
    12,647

    Re: Consolidate workbooks

    Did you get this resolved?

    i have changed the code but i have lost all my buttons on the total sheet. I have tried this now a few times by putting the sheet in different folders but no joy
    The Save Button works like this:
    1. It asks the User where to save the file (what folder).
    2. It removes the Buttons from the worksheet so Macros can't be inadvertently triggered.
    3. It then saves the Total Sheet as an .xlsx file
    4. The original Total.xlsm file remains intact, with Buttons, in it's original location.

    If you know the folder name (or at LEAST the Path), it can be hard coded, which would be my preference.
    I would also recommend removing all code from the .xlsx file. This can be done programmaticly. Let me know.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  3. #93
    Forum Contributor
    Join Date
    07-31-2008
    Location
    UK
    Posts
    104

    Re: Consolidate workbooks

    Hi John, no i couldn't. So i did this and it seems fine now. I added these 2 subs

    Please Login or Register  to view this content.

  4. #94
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2007 2003
    Posts
    12,647

    Re: Consolidate workbooks

    Hi yus786
    Good for you. Just remember my admonition
    Please note, you MUST not save this file in the same folder with your timesheets...it's an .xlsx file and will screw with Total if it's in the same folder
    If this satisfies your requirements, please mark your Thread as solved. You may be beyond the window of time to do so yourself...if so, please ask a Moderator to do so.

  5. #95
    Forum Contributor
    Join Date
    07-31-2008
    Location
    UK
    Posts
    104

    Re: Consolidate workbooks

    Thanks for your help. It's really appreciated. Not many would do what you have done and i thank you from the bottom of my heart

    I still need to design the 'new total file' what we talked about a few days back.

    At the moment, the consolidation is done over weekly timesheets. The requirement would then be to consolidate JUST the total worksheet from each weekly file and make a total.

    Example, in a folder i may put 4 or 5 weekly timesheets and upon opening this NEW total timesheet, it will take just the TOTAL worksheet from each file and consolidate

    Shall i open a new thread for this?

    Thanks John

  6. #96
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2007 2003
    Posts
    12,647

    Re: Consolidate workbooks

    Hi yus786

    Glad to be of help.
    I'd forgotten about this
    I still need to design the 'new total file' what we talked about a few days back.
    and I don't know how to answer this
    Shall i open a new thread for this?
    It's a new issue that's related to your apparently solved old issue. So, that would infer (to me) that you should think about a new Thread...but...on the other hand...there's a direct relationship. I'm not a Moderator so I'm not certain how they would view this.

    The advantage of starting a new Thread is you'll probably get a lot more play...which is good. You won't get too much input from others if you continue the issue in this Tread. When I see a Thread with 95 posts I might look at it to see "What the hay is going on!!!" but I won't jump in with both feet...somebody's probably got the solution surrounded.

    So, I'll leave that to you to decide (unless a Moderator sees this conversation and has a comment). If you do start a new Thread, PM me with a link and I'll look at it. Let me know what you decide.

  7. #97
    Forum Contributor
    Join Date
    07-31-2008
    Location
    UK
    Posts
    104

    Re: Consolidate workbooks

    Hey John, how's it going? Hope all is well.

    Been using the timesheet for weeks and now and sweet as a pie. BUT (Don't you just hate buts), my management now require a change.

    Currently we are reporting on the hours worked per project but what they now need is hours worked tasks per project per country.

    I have included an example - have a look at NewTimesheets_V1 - EE1.xls and NewTimesheets_V1 - EE2.xls
    1. The days are at the top and the new columns are Country and Tasks. I want the ADD Client button to ADD a new row and DEL Client to DELETE. The submit, i can do
    2. Sheet 2 i have left visible for you to see what's going on, but i can hide that later

    Now have a look at the total sheet - TotalV1.xlsx
    1. The first tab needs to have a consolidated total of the lot (like you did on the earlier ones)
    2. Then the next few tabs would be a copy of the individual sheets.
    3. And you can then see the pivot at the end.

    Is this possible to do?

    It's all similar to what you did earlier with the exception of moving the days to the top and adding 2 more categories.

    The purpose of this is so that we can track who's doing which project in which country and which task are they actually working on

    Appreciate your help John
    Attached Files Attached Files

  8. #98
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,145

    Re: Consolidate workbooks

    Yus786,

    I understand you started this thread, but its more than 2 months old. How about starting a new thread? You can provide a link to this thread in your new thread.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  9. #99
    Forum Contributor
    Join Date
    07-31-2008
    Location
    UK
    Posts
    104

    Re: Consolidate workbooks

    Will do, apologies

+ Reply to Thread
Page 7 of 7 FirstFirst ... 5 6 7

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1