TIA,
I can find plenty of answers about how to take data from multiple worksheets and combine them into one... but taking data from one and sending it to others seems to be a little harder to find. I've tried googling it and haven't had much luck in finding answers. I may be wording my query on this topic wrong though. So I come to the HardOCP gurus for guidance once again. This is what I'm trying to do.
I work in a machine shop and I have multiple jobs that I need to track. I want to put all the information for the jobs in one worksheet and then have a worksheet for each month. I just want to send the jobs by month to the corresponding months worksheet. Basically i just want copies of that information from the main sheet in the month worksheets so data only has to be entered in one place. I have to keep it simple so my less computer savvy coworkers can use it. I have a little bit of experience with VBA so with some guidance i think i should be able to muddle my way through it.
Anyways thanks for any help
I can find plenty of answers about how to take data from multiple worksheets and combine them into one... but taking data from one and sending it to others seems to be a little harder to find. I've tried googling it and haven't had much luck in finding answers. I may be wording my query on this topic wrong though. So I come to the HardOCP gurus for guidance once again. This is what I'm trying to do.
I work in a machine shop and I have multiple jobs that I need to track. I want to put all the information for the jobs in one worksheet and then have a worksheet for each month. I just want to send the jobs by month to the corresponding months worksheet. Basically i just want copies of that information from the main sheet in the month worksheets so data only has to be entered in one place. I have to keep it simple so my less computer savvy coworkers can use it. I have a little bit of experience with VBA so with some guidance i think i should be able to muddle my way through it.
Anyways thanks for any help