Dear Members

i have one problem
in one sheet there is data as
party name                              bill no.                       amount

there are 100s of party detail,one party may has many bill no

in another sheet
party name                              bill no.                       amount


i want to extract amount from shhet 2 , if party name & bill name of
sheet 1 are same

in other words, i want to compare both party name and bill no. from
sheet 1 & sheet 2
and if they match i want to get amount from sheet 2

please help me

Have A Nice Time & Enjoy Life

Regards:
CMA Ankur Pandey
(Someone Different)

I'm not the best but i'm not like the rest~~

--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---

Reply via email to