Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
multiple worksheet formula help
I have a 7 page workbook. Page 1 is the "master" sheet containing formulated
data from the other 6 sheets in the workbook. Each of the 6 other sheets are set-up with the exact same rows and columns - they are simply assigned to a different sales representative. I have the representatives "complete" a ROW on their sheet and "copy/paste" that row to the "master" sheet which then formulates the data via "sumproduct" formulas into charts. My problem is that I have 6 representatives who can't even copy/paste without making errors! What I need to do is find a formula that does the following: When a representative goes to one of the 6 worksheets, any ROW they complete will AUTOMATICALLY be COPIED over to the "master" sheet into an empty row. Does such an animal exist? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mutilpe sheet , multiple formula help please. | Excel Worksheet Functions | |||
Recurring Excel Formula error - multiple users affected! | Excel Discussion (Misc queries) | |||
Excel should let me format worksheet tabs in multiple rows. | Excel Worksheet Functions | |||
how do i maintain one worksheet from data from multiple worksheet | Excel Worksheet Functions | |||
Multiple Condition Sumif Formula | Excel Worksheet Functions |