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) |
All times are GMT +1. The time now is 01:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com