Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying data to summary sheet
I have say 12 worksheets for 12 months
each worksheet has say 4 columns "Activity"(in col A), "Start"(in col b), "Finish"(in col c), "Status"(in col d) each worksheet has a definite number of rows for data entry and cant extent beyond these values(ex:A7 to A39 for "activity" similarly b7 to b39 for "start"...) I want to have a summary sheet with the same 4 columns "Activity"(col A), "Start"(col b), "Finish"(col c), "Status"(col d) I have 2 questions 1) whenever a data entry is made in any of the 12 worksheets (between rows 7 to 39 for A, B, C, D colms), the same values should automatically be copied onto the summary sheet. 2) say for example 1st worksheet has a project name "xyz CR", and again to track for next month in 2nd worksheet i enter the same project name "xyz CR". This duplicate should not be entered in the summary sheet. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying a formula down a summary sheet | Excel Discussion (Misc queries) | |||
Consolidate data to summary sheet | Excel Discussion (Misc queries) | |||
How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) | |||
Multiple sheet data summary | Excel Worksheet Functions | |||
Copying Cells From Multiple Worksheets to Create Summary Sheet | Excel Discussion (Misc queries) |