script logic

[#1]

Dear Communit,

I have aa folowing issue

that is  i have two tables

one table having company details with amount and their dates also

other table having only dates that to summeraise dates that means

suppose i have summeraise date that is 30/01/2012

so acoording to this,  below  this date wt amount is having an another table i shold show in chart

how it would possible can any one give me an idea

[#2]

i cant understand what u want from the two sheets

[#3]

i want companies amount from  transaction which is <date in master table

[#4]

wich date field r u referring to in the Master & how to do u identofy which customer is for wich company ?

How the two sheets are linked ?

[#5]

can i send my live excels

[#6]

hi

i' have try to solve this problem, hope the attached file is correct, if not correct then define what u exactly want.

[#7]

Hi

Create a variable for master date field

by using this variable u write the condition

[#8]

yes u can