i have a probelm in summary formula.i have two sheets.one is
weighbridge report and other is the main page name daily comprehensive
sales report. i want to link all the data from weighbridge reprot to
daily comprehensive sales report in a format so that i put the formula
with the link of the other sheet and get the daily summary report of
different customers with different materials with date wise.

materials are
4 in weighbridge report (3/4) in main sheet
2 in weighbridge report (0-2) in main sheet
and so on

other is customer name quantity and date.