+ Reply to Thread
Results 1 to 8 of 8

Date display issues in Consolidation File

  1. #1
    Banned User!
    Join Date
    08-14-2008
    Location
    India
    MS-Off Ver
    Excel 2003 and 2007 - Expertise Novice
    Posts
    69

    Date display issues in Consolidation File

    Hi all

    Wish you all a Merry Christmas and a Happy New Year
    -----------------------------------------------

    Coming to the topic

    I have am developing a master file called “ Real Master File “ which captures (consolidates) data from other individual call trackers like Anne’s Call tracker / Tom’s Call tracker etc

    This data is captured into its respective office like LA Tracker / London Tracker and data from that is consolidated together in Consolidated Sheet ( all sheets are important )

    Though the Master file is running successfully upto 90 % there are few issues that needs to be ironed out

    I would be grateful if some can assist me on this
    ----------------------------------------------------------------------------------------------
    Prerequisite

    Please create a folder in your desktop called " Test" create a sub folder in that as " Master"

    Save user files " Anne , Leena and Tom " into the Test folder and " Real Master File" into Master folder

    ------
    You need to

    Open Real Master file and in Module 4 and probably also in module 1
    And Change the path shown there from

    Please Login or Register  to view this content.

    To your test folder's path

    -----------------------------

    Then you can open Module 4 and Run the macro from there to test the file




    -----------------------------------------------------
    Problems faced in Master File ( help needed on )
    -----------------------------------------------------

    1) Date is not coming up in sub sheets like “ LA tracker or Mexico Tracker “ even though its coming in the consolidated sheet. as you can see its comes as " 0:00"


    2) I need the latest entries to come on top row and oldest below

    3) also is it possible to put a “command button” or something - where I have placed " Run Macro" menu Combined tracker - so that I can run the macro from the sheet instead of always having to go into module 4 )

    4) I am getting an error at the very end of the Macro - cant make out why this is comings
    Please Login or Register  to view this content.


    5) lastly I wanted to check if in the " Analysis Sheet " its possible to have an option to check : - How many calls was taken by each team member in that day and the previous day from the data which has been captured.

    Ps: First attachment consist of the " Master File"

    second attachment will have 3 sample individual files in zipped format

    Thanks in advance

    Cross posted at http://www.vbaexpress.com/forum/show...230#post202230
    and

    http://www.mrexcel.com/forum/showthread.php?t=437872
    Attached Files Attached Files
    Last edited by dimitrz; 12-27-2009 at 05:17 AM.

  2. #2
    Banned User!
    Join Date
    08-14-2008
    Location
    India
    MS-Off Ver
    Excel 2003 and 2007 - Expertise Novice
    Posts
    69

    Re: Date display issues in Consolidation File

    any tips

  3. #3
    Forum Contributor
    Join Date
    09-22-2009
    Location
    Indianapolis, Indiana
    MS-Off Ver
    Office 2003 / Office 2007
    Posts
    114

    Re: Date display issues in Consolidation File

    A question more or less. Why not simply use a DB (Access would work fine) and allow users to write information to that rather than attempting to consolidate several workbooks?

    I'd create a form, provide robust error checking for the form, and then have a "submit" button and call it done. No worries about the end user moving your workbook (no matter where it is, it still works), they cant change around ranges / formats etc. Even if not a form, then a worksheet with styles that is tightly controlled. Also you dont have to worry about if they have the book open, if they save it or not before they leave for the day etc.

    Once you set it up to properly store information, at that point you can do anything you want to with it (any order you want, report by region / person etc).

  4. #4
    Banned User!
    Join Date
    08-14-2008
    Location
    India
    MS-Off Ver
    Excel 2003 and 2007 - Expertise Novice
    Posts
    69

    Re: Date display issues in Consolidation File

    Hi Marzuk as a matter of fact one of my friend is already working on an Access version - however since its a new concept for us - its going slow.

    Thats why we decided to have an excel version till the access based DB is ready and we nearly succeed in this but for the issues faced above - any tips on how to resolve the above is welcome since we have to live with that till we can finish the Access DB part

  5. #5
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Date display issues in Consolidation File

    About #3)
    A Command Button from the Forms menu would be one way to do that.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  6. #6
    Banned User!
    Join Date
    08-14-2008
    Location
    India
    MS-Off Ver
    Excel 2003 and 2007 - Expertise Novice
    Posts
    69

    Re: Date display issues in Consolidation File

    Thanks for the tip on #3 mikerickson
    Any suggestions for other queries ?

  7. #7
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Date display issues in Consolidation File

    Re:#4)
    That code will error if TOP_OF_DATE_COLUMN and TOP_OF_TIME_COLUMN aren't in the Selection.
    Key1 and Key2 have to be cells in the range being sorted.
    Please Login or Register  to view this content.

  8. #8
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: Date display issues in Consolidation File

    Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

    ... and this is not the linked above cross post at vba express!

+ Reply to Thread

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