Combine two sheets

[rose4emi]

Hi,

Im not good in excel, VBA or macro, so i don't know how to consolidate the data i have. I just need to present the data so that i will be able to get a summary of units used and wasted with necessary details. i tried pivot but it doesn't seem to work. Please i badly need help. consolidate data function shows sum and other formulas which i think is not what i need.

Your suggestions are very welcome. Please help.

please see attached. thanks!

[TMS]

I'm not really sure what you need to achieve.

Maybe start with:

=IF(IF(B3="","",COUNTIF('Discarded and Transfused'!B:B,Received!B3)),"Trans/Disc","") ... and copy down

This will indicate whether a Received unit has been Transfused or Discarded.

Or you could use:

=IFERROR(VLOOKUP(B3,'Discarded and Transfused'!B2:G581,4,FALSE),"No Record") ... and copy down

which will return the status if a record is present.


Regards, TMS

[rose4emi]

Hi,

I really appreciate your response. will try it and post the results. Thanks a lot! )

[TMS]

You're welcome. Thanks for the rep.

[TMS]

See the attached updated workook. I hope this helps.

Regards, TMS

[rose4emi]

Hi,

Thanks a lot for the sample sheet. It made it a lot easier for me.

Moving forward, what formula can i use if i want to get a daily count of the data based on multiple criteria?

For example:

Daily Received Sheet - C5 will show the total number of units received on october 1st group A+
Daily discarded & transfused - C5 will show the total number of units discarded on Oct 1st with reason "Expired"

Please help how to write the formula correctly. See attachment

Thanks!

[TMS]

It looks as though COUNTIFS should do it.

However, if the original question has been answered, you should mark this thread as solved and start a new one for the new question. That way, you'll get more interest.


Regards, TMS

[rose4emi]

Hi TMS,

Yup it helped me a lot! I'm still learning the formula you put in there but it's very useful!
Well I'd like to mark this solved but i'm still figuring out how
Obviously I'm really new in this forum, don't really have much time to explore :|

[TMS]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save