Hiya, i have myself a table on the left is all the members names and along the top are 12 dates (1/1/07, 1/2/07 etc). In another sheet i have a drop down box for the name of the person and a dropdown box to select a date and then a space to enter the amount paid so i need a macro that will find the name and date i selected from one sheet and take the amount paid into the other sheet and insert the amount in the correct place. http://i12.photobucket.com/albums/a213/X_III/Add_Payment.jpg Once i have selected the name and date from the dropdown box then entered the amount i wish to enter, once i press the add payment button i need the amount to go into the cell where appropriate as illustrated below. http://i12.photobucket.com/albums/a213/X_I...ments_Sheet.jpg Im not very good with macros so can someone explain it very clearly to me. Thanks in advance.
