hi,

can anybody help me with my worksheet?

I truly dont undesrtand excel at all. Im using excel 2007 and dont know how to use macros

I've been working on a tabulation of suppliers and schedule of their due dates.
What i want is something like this:

Sheet 1:
Column A = Supplier
Column B = Due Date
Column C = Amount

Sheet 2:
a1= Start Date : ___________
b2= End Date : ___________

Column A = suppliers
Column B = Mon
Column C = Tue
Column D = Wed
Column E = Thur
Column F = Fri
Column G = Sat
Column H = Sun
Column I = Next Monday

What i want is for the data in sheet 1 to transfer in sheet 2 given a certain start and end date.
Its sort of basic weekly schedule for due accounts.

Pls. help me.