Hello all,
I am working with 2 different worksheets and need to have info from 1 auto
over to the other in certain cells. 7 sales people on sheet 1 have multiple
sales with multiple forms of payments (ie, CC, Cash Wire etc.). Sheet 2 is a
total for the day, week, month etc. and list each sales person in A1:A7 with
the forms of payment in columns B through H. I know there is a way to match
the forms of payment with the sales person on Sheet 1 to auto populate in the
corresponding cells on sheet 2 but I am drawing a blank. Any help would be
appreciated. Thanks to all...