Check # Amount
111001 75
111002 25
111003 33
111004 66
111005 15
111006 5.26
111007 110
111008 524.03
111009 60.25
111010 85.65
111011 19.45
111012 78.25
this is master tab
this is the weekly tab
111005 15
111010 85.65
the weekly tabs use vlookup to put in amount when you enter check # what i want to do is for each weekly tab when i enter in check # and it enters in the amount i want it to fill the cell in the master tab beside the amount---green or simply enter some text in saying that check is being used and color the cells not being used like red.... so it would need to look at all tabs and if the check # is being used in turn go back to master tab and put some kind of marking on the same row and the next column over from the check # and amount so i can easily see if that check has cleared or not. is there a macro or something i can use to do this? thanks for any help...
Bookmarks