Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula or Macro
The requirement to automatically detect when you've run out of room and need
to move to a new sheet (and when that new sheet exists and therefore must be the 'receiver' of the copied data) pretty much dictates that you're going to have to use VBA. There is no built-in formula in Excel to automatically either add a new sheet or insert a new row. To automatically copy a new entry from any of the 4 individual team sheets to the 5th (and 6th) summary sheets would also require VBA (macro). I'm thinking that in the long run this will probably be a little involved and you may want to work more directly with someone on the project. There is information needed such as when/how do you decide that the 5th sheet is full and you need a 6th one? Just no more rows to write to on it? Some pre-determined number of rows used on it? Things like that. I'd be willing to assist with that if you would like. Just need a copy of the workbook attached to an email to (remove spaces) HelpFrom @ jlathamsite.com along with an explanation of things like I asked above. Otherwise, just post here that you'll continue to seek assistance in this discussion. "MJ" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro or Formula | Excel Discussion (Misc queries) | |||
Formula in Macro | Excel Discussion (Misc queries) | |||
macro or formula | Excel Programming | |||
Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
Sum Formula in Macro | Excel Programming |