P
Peter
Sorry not the best subject line to describe what I am after - not even sure
if possible without using a filter/macro
Sheet 1
Col A Col B
Key Month
Dec
1 Jan
1 Feb
Sheet 2
Col A Col B Col C Col D
31/1/08 £1500 xxxxx xxxxx
30/2/08 £500 xxxxx xxxxx
25/1/08 £750 xxxxx xxxxx
15/12/07 £100 xxxxx xxxxx
Formula to show:-
Where 1 is entered in Key (sheet 1) - sheet 2 all data in that row is shown
for the specific month(s)
if possible without using a filter/macro
Sheet 1
Col A Col B
Key Month
Dec
1 Jan
1 Feb
Sheet 2
Col A Col B Col C Col D
31/1/08 £1500 xxxxx xxxxx
30/2/08 £500 xxxxx xxxxx
25/1/08 £750 xxxxx xxxxx
15/12/07 £100 xxxxx xxxxx
Formula to show:-
Where 1 is entered in Key (sheet 1) - sheet 2 all data in that row is shown
for the specific month(s)