I am trying to write a macro for my database in excel, however, i see it
needs better VB knowledge than mine, which is beginner in fact.

The details a

Three seperate sheets in a workbook, in each sheet there are 4 columns
(A1:A4) and over 5000 rows. an example is:
this is order receipts sheet

Shop Prod. Amount Rec. Date
KES Winx 20000 14.07.05
SA T&J 4998 05.07.05
KIR Batman 15000 11.06.05
OF Concept 40000 01.08.05

this is shipments sheet

Shop Prod. Amount Ship. Date
KES Winx 15000 15.08.05
KIR Batman 12000 13.06.05
SA T&J 5000 09.07.05
OF Concept 40000 09.08.05

now, in the third sheet i want to see the left-over orders and the time
between rec. and prod. date. The problem is, i cannot do this... can
anyone give me some clues???

*** Sent via Developersdex http://www.developersdex.com ***

Hi, Beb,

Just a thought, but wouldn't it be easier to have everything on one
worksheet, with an additional column containing formulae to subtract
shipments from receipts in it, giving a balance? You could hide and unhide
any columns to produce various reports etc.

I don't like coding when i don't have to! :-)

Pete


"beb" wrote:


I am trying to write a macro for my database in excel, however, i see it
needs better VB knowledge than mine, which is beginner in fact.

The details a

Three seperate sheets in a workbook, in each sheet there are 4 columns
(A1:A4) and over 5000 rows. an example is:
this is order receipts sheet

Shop Prod. Amount Rec. Date
KES Winx 20000 14.07.05
SA T&J 4998 05.07.05
KIR Batman 15000 11.06.05
OF Concept 40000 01.08.05

this is shipments sheet

Shop Prod. Amount Ship. Date
KES Winx 15000 15.08.05
KIR Batman 12000 13.06.05
SA T&J 5000 09.07.05
OF Concept 40000 09.08.05

now, in the third sheet i want to see the left-over orders and the time
between rec. and prod. date. The problem is, i cannot do this... can
anyone give me some clues???

*** Sent via Developersdex http://www.developersdex.com ***

You can extract the left-over orders by using MS Query, through the Data menu:

Data-Import External Data...-New Database query

The advantage to this is that you can refresh the data periodically simply
by right-clicking in the results and choosing 'Refresh Data'



"beb" wrote:


I am trying to write a macro for my database in excel, however, i see it
needs better VB knowledge than mine, which is beginner in fact.

The details a

Three seperate sheets in a workbook, in each sheet there are 4 columns
(A1:A4) and over 5000 rows. an example is:
this is order receipts sheet

Shop Prod. Amount Rec. Date
KES Winx 20000 14.07.05
SA T&J 4998 05.07.05
KIR Batman 15000 11.06.05
OF Concept 40000 01.08.05

this is shipments sheet

Shop Prod. Amount Ship. Date
KES Winx 15000 15.08.05
KIR Batman 12000 13.06.05
SA T&J 5000 09.07.05
OF Concept 40000 09.08.05

now, in the third sheet i want to see the left-over orders and the time
between rec. and prod. date. The problem is, i cannot do this... can
anyone give me some clues???

*** Sent via Developersdex http://www.developersdex.com ***

well, here i included only part of a dbase to give example, thus,
actually, my database is much larger and steadily growing, hence, i
guess, same sheet theory does not apply to real situation...

thanx anyway..

*** Sent via Developersdex http://www.developersdex.com ***

thanx, i'll try...

*** Sent via Developersdex http://www.developersdex.com ***