Copy whole row if criteria matches one cell

Hi

I am trying to get my spread sheet to copy over all information in one row if certain criteria is found in one cell.

I have attached a workbook to show you what I mean.
I need the information to feed into 'Commision' sheet if cell S in 'Shutters' workbook displays 'CASH'

I am not good with forumalas and function so if you can help please keep the instructions simple

thanks
Hayley

Hi Hayley,

The excelsheet you have attached it is password protected.

oops try SUMMER123

I saw this thread and figure its maybe what I need, but I dont understand the actual code and what exactly I need to do

http://www.excelforum.com/excel-prog...-criteria.html

test(1).xlsxI did some formulas, but I don't know how to only bring across cells with text. I am still waiting on someone to get back to me about it.

I need it to copy all the row information over if the criteria matches

Hello Dear,
It is not working if it has some blank column Like K in this example.
Else it is working :-)

It is only for sixthsense

Sorry as I said I have very little knowledge of excel. By module do you mean cell?

Hi I managed to do this but it did not pull through all the information including total amounts etc. I removed the blank colum and then it didnt pull through the infromation except headers.
Are you able to help?

Sorry to make this more complicated. Can you get this to pull the information from a different excel file entirely?