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.

The simplest answer to your first question is to type an = into the cell on
the summary worksheet where you want the data to appear then click on the
second worksheet and click on the source cell. Whatever you type in that cell
on the second worksheet will appear on the summary sheet. Copy or replicate
other data entry cells for all other data to appear on you summary sheet.
This will, however, result in a zero appearing in you summary where no data
appears on your source worksheet but can be eliminated by amending the fomula
in your summary sheet thus =IF(Sheet2!A1="","",Sheet2!A1) (amend Sheet2 and
A1 to suit).
Your second question is more complex:
If your first worksheet is named "xyz CR" you cannot name a second worksheet
in the same workbook with the same name!
Can you give more info on your layout of data?


"Max" wrote:

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.

I think my question is not clear to you
i am aware of placing = but what i need is there are 12 sheets with
stipulated colms and rows adn when i enter data there they should reflect in
summary sheet whic will have same columns. If i use = i need to personally
do that each time. Hoep i am right

for 2nd question you have got me wrong, i was not talking about sheet name,
i was telling abuot teh activity description not to be replicated in Summary
sheet
(ex: if i have enterd in Sheet1 under Activity column in cell A8 as "xyz
test",and again in sheet 4 under Activity column in any cell if i type same
activity name "xyz test", the summary should not allow writing this as it
already exisits.- i need this to work as if project lasts 6 months it wil
have entry in each worksheet)
TIA

"Ron@Buy" wrote:

The simplest answer to your first question is to type an = into the cell on
the summary worksheet where you want the data to appear then click on the
second worksheet and click on the source cell. Whatever you type in that cell
on the second worksheet will appear on the summary sheet. Copy or replicate
other data entry cells for all other data to appear on you summary sheet.
This will, however, result in a zero appearing in you summary where no data
appears on your source worksheet but can be eliminated by amending the fomula
in your summary sheet thus =IF(Sheet2!A1="","",Sheet2!A1) (amend Sheet2 and
A1 to suit).
Your second question is more complex:
If your first worksheet is named "xyz CR" you cannot name a second worksheet
in the same workbook with the same name!
Can you give more info on your layout of data?


"Max" wrote:

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.