+ Reply to Thread
Page 5 of 7 FirstFirst ... 3 4 5 6 7 LastLast
Results 61 to 75 of 99

Consolidate workbooks

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

    Re: Consolidate workbooks

    Cheers John. i'll test tomorrow. For info - we'll be using this from next week and we cant thank you enough. THANK YOU

    One final request. At the moment - this is done on a weekly basis.

    However, if i wish to consolidate JUST THE TOTALS from say 5 sheets, is that possible (to make a Monthly total analysis sheet)

    Example: A folder has 4 files - Week 1, Week 2, Week 3, Week 4. Each file has employee timesheets and the TOTAL.

    Now if we wish to consolidate the TOTALS from each week and make a MONTH 1 sheet - is that possible?

    So this will be done once a Month. I can ask the user to save the TOTALS worksheet on a separate folder

    Thanks John

  2. #62
    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 2019
    Posts
    12,749

    Re: Help - need to consolidate workbooks

    Hi yus786

    You design it...perhaps we can build it.
    Mock it up for me so I can see what you visualize...I'll take a look at it.
    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. #63
    Forum Contributor
    Join Date
    07-31-2008
    Location
    UK
    Posts
    104

    Re: Consolidate workbooks

    You the man...

    Before I design that, I have a small request on the current model.

    As it stands, the timesheets will be saved in the relevant week ending folder, so WE_26_Feb, WE_04_Mar etc etc and these folders MUST have the TOTALS file in there. Which means I am going to have to copy the Total_new v3.4.xlsm‎ file on each of the folder.

    So instead, is this possible?

    The Total_new file is JUST the one file. When my manager opens this file, instead of pressing the button which consolidates, how about if a prompt appears where he would select the folder which contains ALL timesheets?

    SO for example, he would have the totals sheet on his desktop. He would open and a prompt would appear for him to select the folder. He would then BROWSE and select the folder which contains the timesheets example WE_26_Feb folder.

    Is this possible?

  4. #64
    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 2019
    Posts
    12,749

    Re: Consolidate workbooks

    Hi yus786

    I've added a UserForm to Total_new v3.5.xlsm such that, when the User clicks the Run Me button, the UserForm is populated with all the available Weekly Time Sheet Folders. The User selects a weekly folder and clicks Proceed.

    You'll need to change the indicated UserForm line of code to the Path and Folder Name where you've stored the weekly folders. Let me know of issues.
    Please Login or Register  to view this content.
    Attached Files Attached Files

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

    Re: Consolidate workbooks

    Thanks John, have you added the code to the attached sheet, or should i being that?

    Cheers

    EDIT: Sorry ignore me, found it
    Last edited by yus786; 02-24-2012 at 03:13 PM.

  6. #66
    Registered User
    Join Date
    02-25-2012
    Location
    New York, USA
    MS-Off Ver
    Excel 2003
    Posts
    6

    Employee list( new hire)

    Greetings community!

    I just joined the forum and hope I came to the right place for my excel challenges.

    Here is my challenge,

    I am hiring over 150 people in a week time and I already interviewed and over 40 people. The new employees will be working in six different departments, three different shift.

    Here is what I want to accomplish,

    Create a master list of new hires and create a different worksheet for each department with different shift.

    I want the formula to pick from the master new hire page and distribute them to their specific department and time in each department worksheet.

    Thank you in advance
    Yankee from .New York :D

  7. #67
    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 2019
    Posts
    12,749

    Re: Consolidate workbooks

    Hi Yankee
    Welcome to the Forum!
    Please take a look at the Forum Rules (click on the Link above). Read all the Rules but, in particular, note Rule #2.

  8. #68
    Forum Contributor
    Join Date
    07-31-2008
    Location
    UK
    Posts
    104

    Re: Consolidate workbooks

    Hey there John. We rolled this out this week and so far so good, althought the Analysis will be done next week

    A quick question. When the total file is saved - it needs to be saved as a .xlsx as it will be email around (so without the macro)

    When i chose save as and then from file type - excel(.xls or .xlsx) - i get the attached message.

    COuld you please code me a 'save as' button where i can just click on this button and the location/browse folder will appear where the file will be saved WITHOUT the macro i.e. as a .xlsx and WITHOUT the warning message as attached below

    Is this possible?

    THanks as always
    Attached Images Attached Images

  9. #69
    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 2019
    Posts
    12,749

    Re: Consolidate workbooks

    Hi yus786
    You've lost me. What is it you're trying to accomplish. All the code resides in Total File. If you save as .xlsx the code will be wiped out and the file will be worthless. Please explain.

  10. #70
    Forum Contributor
    Join Date
    07-31-2008
    Location
    UK
    Posts
    104

    Re: Consolidate workbooks

    Sorry JOhn, let me explain.

    We need to email just the total file to Senior management. Emailing the 'total' file with the codes is blank UNLESS we also email the individual timesheets.

    So after my manager has opened the total file and this has generated the consolodated file, we need to save this as a snap shot

    So the steps:

    1. Employee complete timesheets and save in week ending folder
    2. End of week, manager opens the total file and sees ALL the consolodated data
    3. Manager needs to email the data over to senior management, so needs to save as either .xls or .xlsx

    Please try this and you will know what i mean

    Add to files into folder and open the total file, then save as .xls or .xlsx and you will see the data is still there but the codes do not work, which is fine

    Hope this makes sense

    THanks

  11. #71
    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 2019
    Posts
    12,749

    Re: Consolidate workbooks

    Hi yus786
    See if the attached does as you require. Let me know of issues.
    Attached Files Attached Files

  12. #72
    Forum Contributor
    Join Date
    07-31-2008
    Location
    UK
    Posts
    104

    Re: Consolidate workbooks

    Is this the code

    Please Login or Register  to view this content.

    I've done some work on my copy and just need the code for now

    Cheers, will test

  13. #73
    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 2019
    Posts
    12,749

    Re: Consolidate workbooks

    Hi yus786
    Yes, that's the code. I don't believe any other code was changed.

  14. #74
    Forum Contributor
    Join Date
    07-31-2008
    Location
    UK
    Posts
    104

    Re: Consolidate workbooks

    2 issues John

    1. AFter i save it, it saves it without an extension. So i clicked on the button and browsed to the location and it saved it as "file" (NOT "file.xlsx")
    2. Then i tried to open up the total file and it said "Not a valid extention, file is corrupt"

    Thanks

  15. #75
    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 2019
    Posts
    12,749

    Re: Consolidate workbooks

    Hi yus786
    Show me what this screen looks like when you click the Save Button
    Save As.jpg

+ Reply to Thread
Page 5 of 7 FirstFirst ... 3 4 5 6 7 LastLast

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