copy data from sheet to another based on multiple criteria

[MKLAQ]

hi experts

this is the first post and I know what I request is very huge and may be very complicated but honestly, what I see in this forum there are many members help each other and I have no experience about the vba so what I want I have sheet contains many data for many customers and I have another sheet this should show the result for many standards

1 if I select the only from cell a1 the name should bring the data for this name from sheet "process

2 if I select the the cell a1 & a3 , b3 then bring all of the for this name which locates between two dates

3 if I select only a3,b3 then brings all of data for many names which locates between two dates

4 if I the cells a1,a2,a3 are empty should bring all of data

this is general explanation but I have more details in the file and how shows the result and how bring the values and calculate

if the explanation is not clear I'm ready to make clear more
I put simple sample in sheet "result" to understand how is the result
Microsoft OneDrive - Access files anywhere. Create docs with free Office Online.

thanks in advance

 

[aRandomHelper]

I put simple sample in sheet "result" to understand how is the result

The link you have shared is not working anymore

 

[MKLAQ]

aRandomHelper I will find way , may you give me some time ,please ?

 

[MKLAQ]

this is a new link
report client1

 

[MKLAQ]

?

 

[aRandomHelper]

I know what I request is very huge and may be very complicated

That is indeed quite a project you're asking. Do you have any progress so far by yourself?

To get the whole thing done faster, instead of having someone doing everything for you for free, you can first start off with a simple task like maybe just the 1st requirement. To be honest, people would be more willing to help in smaller bits.
Once you got something going, try to learn from there how people are doing it, then adapt it and make changes here and there by yourself, then probably try asking again when you bump into the next problem. I can honestly say that I won't have enough free time to do everything for you, but I'll happy to help you with smaller problems once you have something going.

 

[MKLAQ]

thanks I expect that for a huge the project this is my mistake I had to post one thing not many things
thanks for your advice

 

[aRandomHelper]

I would say, the first step would be to build the "interface" and think of how your process flows.
Do you want to type in the names/dates, or choose from a drop down list or something? Do you want to search when you click a button?
Build up the boxes/cells, colour them, border them up nicely etc, make a button. Get something going first. That's because if anyone is going to help you, they would be doing these for you and it feels like a chore.

 

[MKLAQ]

yes I would select form the dropdown in a1 and write from date to date in a3,b3 is my file not clear ?

 

[mumps]

In order to do what you want, you would have to add another column in PROCESS which contains a unique identifier for each row. Could you upload a new version of the file which includes the unique identifiers?