please help with macro.

[pakilprogramador]

why do not filter the data I am doing wrong??

please help me thanks

regards,

 

[Hui]

If I set SQLVISTA!E2 to 28/08/2014
I get:


What should I get?
Can you please tell us what values don't work and what we should get?

If you are using a 64Bit Excel you will need to update 4 lines:

 

[pakilprogramador]

hi @Hui
I have windows xp 32 bits.

filter data of the two dates and sum total

attach example

 

[NARAYANK991]

Hi ,

See your file now.

Narayan

 

[pakilprogramador]

hi @naranyank991
thanks, You can make these changes Please, thank you very much

 

[NARAYANK991]

Hi ,

What would the logic be ? Can you explain ?

Narayan

 

[pakilprogramador]

yeah of course,

choosing day Range E2 and show all data of that day and ,FACTURA-MES next month.
for example :

 

[NARAYANK991]

Hi ,

See this file.

Narayan

 

[pakilprogramador]

yeah this is perfect,

but the sum TOTAL for each billed???

THANK YOU VERY MUCH

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[pakilprogramador]

how do you can adding the total amounts? please thanks

 

[NARAYANK991]

Hi ,

See this file.

Narayan

 

[pakilprogramador]

Thank you very much @NARAYANK991 you're the best

regards,