View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jamie Jamie is offline
external usenet poster
 
Posts: 191
Default Adding a Row to Multiple Worksheets at Once

Im working in Excel 2003. Im working on a project that will track
employees errors (dollar, procedure, or no errors). I have 13 worksheets.
The first one is titled Summary and is followed by worksheets titled January
through December. The Summary worksheet functions as the control. The user
enters each employees name on the Summary worksheet into cell A7. The
employees name is automatically entered into cell A7 in the January through
December worksheets using =Summary!A7.

The table it self consists of 3 rows and begins on Row 6. Column titles
include (employees name, etc.). The user types employee information into
Row 7. Row 8 is a Total row.

What I would like to be able to do is, have a button on the Summary
worksheet that triggers a macro which will add a row below row A7 (new row is
A8) in all 13 worksheets.

--
Jamie