Auto sum from one sheet to another thru macro

In the attachment, there are three sheets i.e. LADY, GENTS & SUMMARY, I take the sum of a date from LADY & GENTS sheets to SUMMARY sheet everyday, now I want to automate this process, for this purpose I need a macro whenever I run the macro it takes the sum of GENTS & LADY of the last sum to the SUMMARY sheet.

HI Mr. PCI
I don't think you understand the question, I just want to take the sum of every individual date to the SUMMARY sheet, if you see the LADY & GENTS sheet, and also see the last date on both the sheet i.e. 08/01/2018, I just want to take the sum of both dates in summary sheet as an example 34,346 of gents and 7,900 of lady to the summary sheet. Please see the attachment, now I highlighted the figures which I want to take.

geniusufo007,

Are the dates in both Lady/Gents match to the dates in Summary?

You have block of 2018/Jan/1 then block of 2018/Feb/1 and so on while Summary have 2018/Jan/1, 2018/Jan/2 so on.

Yes, the date must be match with the figures. As you may see the sum of both (gents/lady) are showing under the heading of gents and lady in the SUMMARY sheet with the same date in the (gents/lady), there is no FEB in the attachment, all the date are of Jan, 2018

If the dates match, this should work,(doesn't work here because of the reason I mentioned)

Please Login or Register  to view this content.

Sir,
Look at the attachment, I have run your macro on the attachment but it takes only the first sum not the others please see

That's why I mentioned about your dates.

Put this formula in somewhere in Lady sheet

=TEXT(A15,"yyyy/mmm/d")

it shows 2018/Feb/1, not Jan/2, so my code doesn't work.

Thank you Mr. Jindon that's really great solution and also thanks Mr PCI