Data form to search and enter data

[WESTERNWALL]

Following is a worksheet for which I need a macro.

When date is red then delete entry: 2/11/2005

DATE VOUCHER# CHEQUE # Details AMOUNT

01/11/2005 1020498 50300 John ₪ 3,400.00
01/11/2005 1020694 8800826 James ₪ 1,700.00
02/11/2005 1019563 10498 Jill ₪ 650.00
03/11/2005 1020906 15262404 Sam ₪ 45,000.00


This is a list of post-dated cheques that I will update at the end of each month.
I will delete all entries where the date is in red ie cheques that have
been deposited. I have conditionally formatted the Date column so that when the date changes on the top of the page the dates before that date will turn red. New cheques will be entered at the end of the month
that were received during the month.


I need a macro that can do the following:
1. As I flick through the file containing the cheques I want to
make sure that the cheque appears on the list. I can look it up by either the voucher # or the cheque #. If it does, I'll go to the next one, and so on.
2. Where there is a cheque not found on the list I want to be able to enter it in a data form according to the headings at the top of the form.

Hope it's all understandable!!!

Thanks

Brian

 

[BrianB]

There is an inifinite number of possibilities here. They all boil down to a scenario like this. I suggest you structure your code based on this :-

1. Get value to look for
2. 'Find' the value (single or multiple workbooks/worksheets)
3. Take action if the value is found ?
Take action if the value is not found ?


Here are some examples :-

FIND RECORDS AND PUT INTO SUMMARY
http://www.mrexcel.com/board2/viewtopic.php?t=150953&highlight=

LOOK UP VALUES IN ANOTHER WORKSHEET
http://www.mrexcel.com/board2/viewtopic.php?t=149439&highlight=

FIND MULTIPLE MATCHES IN ALL WORKSHEETS
http://www.mrexcel.com/board2/viewtopic.php?t=148374&highlight=

FIND & HIGHLIGHT MULTIPLE CELLS
http://www.mrexcel.com/board2/viewtopic.php?t=148345&highlight=

 

[WESTERNWALL]

BrianB

Thanks for your response. I'll check it out and let you know.

Regards

BrianM