Copy whole row if criteria matches one cell

[HayleyH86]

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

[Swapnanjali]

Hi Hayley,

The excelsheet you have attached it is password protected.

[HayleyH86]

oops try SUMMER123

[HayleyH86]

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

[Shansy]

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.

[:) Sixthsense :)]

Please show the expected output in your file for suggesting exact code for your requirement

[HayleyH86]

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

[jraj1106]

Hi.

You can try this:

test copydata.xlsm

[:) Sixthsense :)]

Copy and paste the below code in standard module and return to excel and press Alt+F8 and select MatchAndGetData and Click Run.

Please Login or Register  to view this content.

[Swapnanjali]

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

[:) Sixthsense :)]

@ Swapnanjali,

The message is for whom?

[Swapnanjali]

It is only for sixthsense

[:) Sixthsense :)]

Yes, there should not be any break in column headers.

[HayleyH86]

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

[HayleyH86]

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?

[HayleyH86]

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