I wanted to have data in summary tab from first tab of urea and 2nd tab of EDAP. In Urea and EDAP tabs, SLoc is also repeating so data in summary should be sum of all repeating SLoc. In Summary there is date on top left so summary should fetch data from urea and EDap tabs only for that particular date. Thanks for helping. Excel sheet is attached.
You could try a SUMIF(1st-sheet)+SUMIF(2nd-sheet)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Not working for me. Can someone please put formula in excel sheet and reattach it?
Show some samples answers please
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks