Hi...
I need to extract from the sheet 1 data table - the worked time marked in green cells for one month to the sheet 2 table.
I need to match the name and the date and the value from green cell ofcourse!
Could anyone help me and at what cost?
Hi...
I need to extract from the sheet 1 data table - the worked time marked in green cells for one month to the sheet 2 table.
I need to match the name and the date and the value from green cell ofcourse!
Could anyone help me and at what cost?
If you can drop the spelled out day from Sheet1!E:E, you won't actually need any vba for this, a sumproduct will work:
=SUMPRODUCT(N(Sheet1!$D$2:$D$2000=Sheet2!$C10),N(DAY(Sheet1!$E$2:$E$2000)=Sheet2!F$9),Sheet1!$S$2:$S$2000)
I've attached the tweaked spreadsheet:
pontaj-adsoft.xls
Thank you! Great Job! You saved me 100 years of work
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks