| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please help me in Macros
I am having a report like this
03:30 10 Mar 05 Mar 31 Mar Hourly 368 369 259 Confirmed 2383 2317 1773 Cancelled( this Hr.) 38 42 47 Cancelled Total 331 413 362 Hourly Cancel in % 10% 11% 18% Pending (this Hr.) 29 3 12 Pending total 218 164 233 Hourly pending (%) 8% 1% 5% Homepage(visit) 50051 48747 51728 Search results(visit) 25936 24903 28373 Review Page (visit) 8731 8544 8285 Hourly Home 7109 7482 7842 Hourly Search 3694 3812 4347 Hourly Review 1224 1361 1130 Ratio of HS & HP 0.5196 0.5095 0.5543 Ratio of HR & HP 0.1722 0.1819 0.1441 Conversion(this hour) 0.0996 0.0968 0.0596 Total Conversion 0.0919 0.0930 0.0625 Review Conversion 0.3007 0.2711 0.2292 & I have this data for every hour 9:30, 10:30, 11:30 , so on. I want to make like this. Saturday 2-Feb 9:30AM Confirmed 117 Daily Saturday 2-Feb 9:30AM Home Page 2336 Daily Saturday 2-Feb 9:30AM Search 1236 Daily Saturday 2-Feb 9:30AM Ratio 0.5291 Daily Saturday 2-Feb 9:30AM Conversion 0.0947 Daily Saturday 2-Feb 9:30AM Confirmed 87 Hourly Saturday 2-Feb 9:30AM Home Page 7680 Hourly Saturday 2-Feb 9:30AM Search 3914 Hourly Saturday 2-Feb 9:30AM Ratio 0.509635417 Hourly Saturday 2-Feb 9:30AM Conversion 0.0956 Hourly Please help me is there any macro who help me. Thanks with Regards Dinesh |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macros in Personal.xls that would create two toolbars and buttonswith assigned macros | Excel Programming | |||
| choose default macros Not Enabled / Macros Enable Setting | Excel Programming | |||
| weird saving of a document with macros resulting with macros being transfered to the copy | Excel Programming | |||
| convert lotus 123w macros to excel macros | Excel Programming | |||
| Macros not appearing in the Tools Macro Macros list | Excel Programming | |||
Threaded Mode
