Help regarding Validation Function Drop Down....

[ajayxlnc]

Hello,


I need help regarding Validation drop down menu. I have a file which will track the Funds collected by 20 people month on month.

I am using Offset function to pull the data through the drop down menu but i am not able to do that. Please help me out in this as this is for a Charity purpose and I need your help in this Issue. If the template which i have prepared is not that good pls suggest a proper template which will fulfil my needs in a very presenting way.


I have 7 Columns and 20 rows of data in the table. I have created the same tables for all the months O4 to CT4. I have prepared a template (B4 to H4).


My requirement is when i select the month in B4 i need the data to be pulled from the corresponding tables O4 to CT4.

I used Offset function (Is it an appropriate function here) but that is not helping me out. When I select the Month from the Drop down in B4 i need the Data of Donor Name, Transfered Date, Bank, Reference No, Amount, Status, Notes to be displayed in the main template B5 to H5. Column J to CT will be hidden.


Please help me out in this regard. This is for a charity purpose.


Sample file attached....Link for the file


https://docs.google.com/open?id=0B_8nXiEldUKKM2JHQ2x3cXJMNTQ

 

[Debraj]

Hi Ajay,


Happy to know that I have tried to help in some charity purpose..


in B6, write formula as

=OFFSET($O$4,ROW($A1)+1,(COLUMN(A$1)-2)+MATCH($B$4,$O$4:$CT$4,0))

Copy in all area..


https://dl.dropbox.com/u/78831150/Excel/The%20Trumpet%20Shall%20Sound%20Charity%28ajayxlnc%29.xls


Regards,

Deb

 

[ajayxlnc]

Thanks Deb, it works like a charm. Thanks a ton.