J
Joey
Hi all
Please help!!!
Is it possible to transfer data from one sheet to another when th
sheets contain data refering to dates in accompanying cells.
The data transfered should appear as a "1" alongside the date and nam
of the person it's regarding.
Example:
Worksheet 1
If cell A1 = 01/02/04 and B1 = John Doe
If cell A2 = 03/02/04 and B2 = Micky
If cell A3 = 04/02/04 and B3 = Donald
Then Worksheet 2
A2 = John Doe and B1 = 01/02/04 and B2 = 1
A3 = Micky and C1 = 03/02/04 and C3 = 1
A4 = Donald and D1 = 04/02/04 and D4 = 1
Thankyou
Joe
Please help!!!
Is it possible to transfer data from one sheet to another when th
sheets contain data refering to dates in accompanying cells.
The data transfered should appear as a "1" alongside the date and nam
of the person it's regarding.
Example:
Worksheet 1
If cell A1 = 01/02/04 and B1 = John Doe
If cell A2 = 03/02/04 and B2 = Micky
If cell A3 = 04/02/04 and B3 = Donald
Then Worksheet 2
A2 = John Doe and B1 = 01/02/04 and B2 = 1
A3 = Micky and C1 = 03/02/04 and C3 = 1
A4 = Donald and D1 = 04/02/04 and D4 = 1
Thankyou
Joe