maxx_daddy
Board Regular
- Joined
- Dec 3, 2010
- Messages
- 74
Hi,
I am making a sales trackng sheet for my company. Basically what I am doing is making a report page. We have 6 people that could enter data into the sheet via a user form. One of my columns (data validation) is set to have their name.
Also one of my rows is a VBA (copy, paste special) time stamp that I use to sort.
Now the tricky (for me anyways) part.
I have two cells that will eventually be on a user form, one is "start date" and one is "end date".
I made another row in the sheet that has a formula that checks to see if the timestamp is between the start and end date and if it is it returns a "YES" that my macro finds, copies the entire row and pastes it to a temporary sheet. (I understand that is likely the hard way, but I'm new and it was working)
What I want to do is to ALSO search by salesperson so I could see who sold what during a certain period of time.
So I would like help formatting a macro that uses my STARTD and ENDD and maybe check box or combo box to select a salesperson (or all) We will never have more than 1000 sales in a year that go into this system so a loop isn't the worst thing in the world.
Thanks
MAXX
I am making a sales trackng sheet for my company. Basically what I am doing is making a report page. We have 6 people that could enter data into the sheet via a user form. One of my columns (data validation) is set to have their name.
Also one of my rows is a VBA (copy, paste special) time stamp that I use to sort.
Now the tricky (for me anyways) part.
I have two cells that will eventually be on a user form, one is "start date" and one is "end date".
I made another row in the sheet that has a formula that checks to see if the timestamp is between the start and end date and if it is it returns a "YES" that my macro finds, copies the entire row and pastes it to a temporary sheet. (I understand that is likely the hard way, but I'm new and it was working)
What I want to do is to ALSO search by salesperson so I could see who sold what during a certain period of time.
So I would like help formatting a macro that uses my STARTD and ENDD and maybe check box or combo box to select a salesperson (or all) We will never have more than 1000 sales in a year that go into this system so a loop isn't the worst thing in the world.
Thanks
MAXX