| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP!! can't write necessary macro...
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 *** |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I am trying to write a macro using If...Then | Excel Discussion (Misc queries) | |||
| How to write a macro | Excel Discussion (Misc queries) | |||
| is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
| Q: how can I write this macro? | Excel Discussion (Misc queries) | |||
| How do I write a macro for... | Excel Discussion (Misc queries) | |||
Threaded Mode
