View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joco Joco is offline
external usenet poster
 
Posts: 24
Default 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)