Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summary Sheet Macro
Hi,
I have a spreadsheet which contains details of telephone calls, costs and duration etc, in column's A to M and there are about 1,500 lines. Column E has the name and H the number. Lines 1 & 2 are headings, 3 is blank, 4 onwards data, with the last line being totals I would like to create a summary page (formated the same as the detail page, which is printable) which list all the telephone records for a specific name or number, so that I can quickly see all the calls made, the topics discussed, and with whom. I understand a macro would achieve this, but I don't know where to start in compiling a macro to do this. My knowledge of macro's is virtually zero. My OS is XP Home with SP2, and I have Office SBE 2003 (no database) Any help in accomplishing this would be of great value to me. Thanks Joco (London) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) | |||
Summary Sheet | Excel Worksheet Functions | |||
Summary Sheet | Excel Worksheet Functions | |||
Relative Sheet Reference (Summary Sheet) | Excel Discussion (Misc queries) | |||
Summary sheet | New Users to Excel |