Hi All,
i have a quick question, (see attached file for how my database looks, its an excerpt from a large database)Book1.xls
here is what i would like to happen.
I want my Macro/VBA to search column B and C, if B and C match an entry in seperate "employee" database i am constructing then i wish for all data related to that individual in column E to be summed up and the total plugged into a seperate sheet.
I am in newbie catagory so bear with me. I was going to do if and then statements over and over but then i researched creating a seperate worksheet with all the staff names instead of putting them in the code would save a lot of time.
i guess my main concern is how do i write the following in code
"if column b and c are both equal to column a and b in employees sheets then all instances of where B and C equal sheets data E must be summed and totalled."
Bookmarks