LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
MJ MJ is offline
external usenet poster
 
Posts: 1
Default 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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro or Formula terilad Excel Discussion (Misc queries) 5 March 5th 10 09:49 PM
Formula in Macro nc Excel Discussion (Misc queries) 2 July 19th 09 10:00 AM
macro or formula CMD Excel Programming 2 October 4th 06 08:58 PM
Formula expected end of statement error, typing formula into cell as part of VBA macro [email protected] Excel Programming 1 July 20th 06 07:58 PM
Sum Formula in Macro Tim U[_2_] Excel Programming 3 June 9th 05 02:18 PM


All times are GMT +1. The time now is 09:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"