Belindakzn
New Member
- Joined
- May 15, 2014
- Messages
- 5
Hi all,
I need to make a excell spreadsheet for my company except I have no idea how to do this and if it is possible.
I need to enter in data into rows on Sheet 1. It will have quite a few headings and a picture next to the entered data. the last column will be a month that the job will be done eg: 05 or 06.
I would like to know is it possible for me to enter in the date in my last column of sheet 1 and excel automatically sends that entire row only onto anther sheet named 05 for jobs done in May. So on sheet 1 I will have all the quoted work listed as it comes in and excel sorts that to Sheets for the appropriate month?
I hope this makes sense. I can upload an example of this if it will help.
Thanking you in advance!
I need to make a excell spreadsheet for my company except I have no idea how to do this and if it is possible.
I need to enter in data into rows on Sheet 1. It will have quite a few headings and a picture next to the entered data. the last column will be a month that the job will be done eg: 05 or 06.
I would like to know is it possible for me to enter in the date in my last column of sheet 1 and excel automatically sends that entire row only onto anther sheet named 05 for jobs done in May. So on sheet 1 I will have all the quoted work listed as it comes in and excel sorts that to Sheets for the appropriate month?
I hope this makes sense. I can upload an example of this if it will help.
Thanking you in advance!