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
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