Relating date between sheets in same workbook

**honestsoul** · 02-21-2009, 12:08 AM

I have a workbook that has daily task against each name.
example:In sheet 1(tast traker)
A B C
------------------------------
MANAGING RAM 27-JAN-09
DOCUMENT SHAM 29-JAN-09
FINANCE NEHA 07-feb-09
CALLS PUJA 09-feb-09

and sheet 2 is named as RAM,sheet 3 as SHAM,sheet 4 as Neha, sheet 5 as Puja in same workbook

I want when in sheet 1 in column B, i add a new row for say RAM and its related data in column a and column c,it sould automactically upadate the sheet 2 ram with those data in column a and column c.If in sheet 1 in column B, i add a new row named as NEHA and its related data in column a and column c,it sould automatically update the sheet 4 with those data as above.

I assume that a VBA program can be written,but is it possible with inbuilt functions?

Thanks

**honestsoul** · 02-21-2009, 12:10 AM

I have a workbook that has daily task against each name.
example:In sheet 1(tast traker)
A B C
------------------------------
MANAGING RAM 27-JAN-09
DOCUMENT SHAM 29-JAN-09
FINANCE NEHA 07-feb-09
CALLS PUJA 09-feb-09

and sheet 2 is named as RAM,sheet 3 as SHAM,sheet 4 as Neha, sheet 5 as Puja in same workbook

I want when in sheet 1 in column B, i add a new row for say RAM and its related data in column a and column c,it sould automactically upadate the sheet 2 ram with those data in column a and column c.If in sheet 1 in column B, i add a new row named as NEHA and its related data in column a and column c,it sould automatically update the sheet 4 with those data as above.

I assume that a VBA program can be written,but is it possible with inbuilt functions?

Thanks

**JBeaucaire** · 02-21-2009, 04:14 AM

Like this?

**honestsoul** · 02-21-2009, 06:18 AM

Thanks a lot Beaucaire
for the above workbook
actually tried with those formula in my original sheet but its showing some error.Am new to these formula.
am attaching the workbook. kindly check it why its showing error.(Error is #value!)

**JBeaucaire** · 02-21-2009, 12:14 PM

Originally Posted by honestsoul

Thanks a lot Beaucaire for the above workbook actually tried with those formula in my original sheet but its showing some error.Am new to these formula. am attaching the workbook. kindly check it why its showing error.(Error is #value!)

Lot's of references to another book, the "entries" COUNTIF formula was pointing at the wrong column on the first sheet, and the small(if) array works best if it just starts at row 1, so I unmerged your merged cells in the grey section.

**honestsoul** · 02-22-2009, 03:32 AM

hey dude thanks a lot....
I got the reason for the error...
Thanks..........

**JBeaucaire** · 02-22-2009, 04:17 AM

If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED]

**Leith Ross** · 02-22-2009, 06:39 AM

Please share what information you have with the forum members. Yes, there are times when the complexity of the code or its volume precludes providing examples. However, you can still describe in detail the processes that are involved in arriving at a solution to the problem.

**nzm** · 03-10-2009, 12:31 PM

Hello, I think this thread is what I am excactly looking for! Is it possible to send you the excel worksheet example or so that my worksheets are also formulated to do the same thing? Or do I just have to copy & paste the same formula onto my work book? My workbook has more worksheets and more columns in the first sheet.

Thank you for spending time to read my thread.

Best regards,
nzm