Formula or Macro
Which would be the easiest way to accomplish the following task in your
opinion.
I have 4 sheets that will have data entered from 4 separate teams (1
sheet assigned to each team). The data will be in cells A through E and
only occupy one line per entry on the 4 sheets.
They want the data from the 4 sheets to be auto-copied to a 5th sheet
(Summary page) and also automatically copy the data from one line to
the next, to the next. I know how to make the data copy to the 5th
sheet, just not start a new line (or sheet eventually) each time it is
entered one the original and copied to the Summary page. Any help would
be great. Thanks.
|