Populate report from date to date for many ID

[abdo meghari]

Hello
I search for macro to deal for each sheet .
in two sheets I have data for items in columns D:F and the price in column H . so what I want when merge duplicates items based on matching columns D: F and when repeat the same item with different price should use price averages but when merge items should be separated for each sheet alone , also when merge quantity should just be for SVR sheet (means ignoring QTY totally in SR sheet when merge as I did last sheet .
when merge data should be based on two cells (dates) should merge within two dates in E2,G2 . if the E2,G2 are empty then should be empty from row 5 .every time run the macro should clear data from row5 before brings the data without delete formatting and borders , not repeat to the bottom the same data have already copied.
in REPORT sheet SVR header is averages prices from column H for SVR sheet ,SR header is averages prices from column H for SR sheet and in last row(TOTAL) should sum the columns I,J,K and in column L will subtract and sum for I:K as I put the formulas .
if they data are existed in SVR but not in SR should show in REPORT sheet , but if they data are existed in SR ,not in SVR should NOT show in REPORT sheet .
finally when copy data to report sheet I want keep the formatting (numbers,borders....) .
thanks

[sintek]

Hey there abdo...
The date population part I do not understand...
This renders your expected result though...

[abdo meghari]

Hi sintek

The date population part I do not understand...

I want creating report based on two dates . should not merge for all ID without depend on two dates .
just merge based what data start and end date also between two dates and ignore merging before start date and after end date and when dates cells are empty then should not show anything
edited file to understand how could be

[sintek]

Yet you do not provide the between dates?

[abdo meghari]

Yet you do not provide the between dates?

sorry !
would you see edited file,please?

[sintek]

Need an entire different code approach for this...Will revert back a bit later...Off to work now...

[sintek]

Based on these dates, your output result is incorrect...

[abdo meghari]

Based on these dates, your output result is incorrect...

OMG!
sorry again I was hurry .
it's corrected.

[sintek]

And another error...see green value below...

Untitled.png

[JohnTopley]

Please Login or Register  to view this content.

[abdo meghari]

And another error...see green value below...

understood , sorry again !
as to your new version seem this is what I want , but I need some time to make sure .
I will inform you today .

[abdo meghari]

Hi JohnTopley ,
thanks but I note your code showing new ID in SR sheet but is not existed in SVR sheet also when the ID is not existed in SVR sheet within date I note showing .
the highlighted rows shouldn't show based on dates.

[JohnTopley]

See attached

Please Login or Register  to view this content.

[abdo meghari]

Thanks sintek & john !
just remains one thing : if the E2,G2 are empty then should be empty from row 5 . as I mentioned in OP.

[JohnTopley]

Why would you run macro with these fields empty ?

Please Login or Register  to view this content.

[sintek]

Please Login or Register  to view this content.

[abdo meghari]

thanks John , but after clear data when there is no date and try write dates again to populate data will shows application defined error in this line

Please Login or Register  to view this content.

[abdo meghari]

thanks sintek , but but after clear data when there is no date and try writing dates again , then it doesn't show data. the cells keep empty from row 5!

[JohnTopley]

I don't have any problem deleting the dates and then adding dates again!

You will get an error if there is no data in the dates used.

Add highlighted line

Please Login or Register  to view this content.

[abdo meghari]

You will get an error if there is no data in the dates used.

umm, thanks for your notice , but your suggestion will cancel option in post #15

[JohnTopley]

No it does not: if you do not enter dates it will clear the data but if you enter dates for which there is no results then the added test will/should prevent the error.

I am out!

[abdo meghari]

you can test it yourself .

[JohnTopley]

Wrong (not updated) macro: see post #15.

[abdo meghari]

Please Login or Register  to view this content.

is that wrong place?

[JohnTopley]

YES:

Please Login or Register  to view this content.

[abdo meghari]

thank you so much John

[sintek]

oops...my bad...

Please Login or Register  to view this content.

[abdo meghari]

oops...my bad...

no problem
thank you so much for correction .