PDA

View Full Version : Date display issues in Consolidation File



dimitrz
12-24-2009, 04:50 AM
Hi all
Wish you all a Merry Christmas and a Happy New Year :hi:
-----------------------------------------------

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

" 'This_path = "C:\Documents and Settings\dimitrz\Desktop\Test folder"
This_path = "C:\Documents and Settings\dimitrz\Desktop\Test folder" "

To your test folder's path

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

Then you can open Moudle 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

" Selection.Sort Key1:=Range(TOP_OF_DATE_COLUMN), Order1:=xlAscending, Key2:=Range(TOP_OF_TIME_COLUMN), Order2:=xlDescending"

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.excelforum.com/excel-programming/711874-date-display-issues-in-consolidation-file.html#post2221931

dimitrz
12-24-2009, 04:56 AM
This attachment contains 3 sample user sheets/tracker from which the data is captured and consolidated in the master file

dimitrz
12-27-2009, 12:24 AM
: pray2: any tips guys :dunno :help

Ps: Have cross posted this at Mr Excel aswell http://www.mrexcel.com/forum/showthread.php?t=437872 (http://www.mrexcel.com/forum/showthread.php?t=437872)

dimitrz
01-05-2010, 10:09 PM
# 4 is resolved - however other issues still persist

also one more problem is noticed - the consolidation macro is also capturing data from the temp files within the same folder leading to duplicate entries

rbrhodes
01-06-2010, 09:10 PM
1) Ontario has been moved to India?

2) Quote from ExcelForum ( http://www.excelforum.com/excel-programming/711874-date-display-issues-in-consolidation-file.html ) : "Cross posted at http://www.vbaexpress.com/forum/show...230#post202230 (http://www.vbaexpress.com/forum/showthread.php?p=202230#post202230)
and http://www.mrexcel.com/forum/showthread.php?t=437872 (http://www.mrexcel.com/forum/showthread.php?t=437872)"

* added as a PS after warnings rec'd... So:

3) I could help, but not for free... 3 x Xpost? and possibly more?

As one post says # 1 is possibly solved (but being tested) and another says # 4 is solved... and this one does not - who knows?



Sub WasteTimeandConfuseAllEndlessly

Dim Someone_Helpful as Boolean

'//Return here
GetMoreHelp:

SomeOne_Helpful = True

'//Create endless loop
Do While SomeOne_Helpful <> = "wha...?"

Select Case Someone_Helpful
Case = ExcelForum
GoTo MrExcel
Case = VBA Express
GotTo ExcelForum
Case = MrExcel
GoTo VBAExpress
Case Else
GoTo Hell
End Select

Hell:

Loop

Set Someone_Helpful = "wha...?

Goto GetMoreHelp

End Sub





...Moving on...