Which Function is use?
 

Hi to all
in My workbook i have Filed in data sheet like...
Date,Group,PartyName,Amount
1-july, Payment,abc,2345
1-july,Payment,xyz,6790
1-july,Recipt,pqr,8900
2-july,recipt,jjj,9000
2-july,payment,mmm,8907

I have created 30 worksheet with every datename in all worksheet i have
format like...

Date:- 1-July
Payment Recipt

a1, b1, c1, d1,
PartyName,Amount Partyname,Amoumt.
abc,2345 pqr,8900
xyz,6790

what i want is from datasheet i want to lookup date wise data in every
worksheet. I entry all data in datasheet and then from datesheet i can view
per date data but vlookup is not working can any one will help which function
can i use to view per day data in different worksheet.

Thanks in advance.
Tiya

Hi Tiya

Your data would be very suitable to nuse a Pivot Table to extract the
information you require.
Take a look at
http://peltiertech.com/Excel/Pivots/pivotstart.htm
and
http://www.contextures.com/xlPivot02.html
for examples and help on how to set about this.

--
Regards

Roger Govier


"Tiya" wrote in message
...
Hi to all
in My workbook i have Filed in data sheet
like...http://www.contextures.com/xlPivot02.html
Date,Group,PartyName,Amount
1-july, Payment,abc,2345
1-july,Payment,xyz,6790
1-july,Recipt,pqr,8900
2-july,recipt,jjj,9000
2-july,payment,mmm,8907

I have created 30 worksheet with every datename in all worksheet i have
format like...

Date:- 1-July
Payment Recipt

a1, b1, c1, d1,
PartyName,Amount Partyname,Amoumt.
abc,2345 pqr,8900
xyz,6790

what i want is from datasheet i want to lookup date wise data in every
worksheet. I entry all data in datasheet and then from datesheet i can
view
per date data but vlookup is not working can any one will help which
function
can i use to view per day data in different worksheet.

Thanks in advance.
Tiya