Copying data from one cell if another cell if a 3rd cell meets the correct criteria.

**MM68** · 10-30-2013, 01:03 PM

Hi

I am trying to get the info in ‘cell A’ to copy across to another worksheet if ‘cell D’ says something specific?

i.e.

Cell A = Supply
Cell D = 52
The cell in the new worksheet needs to copy over 52.

If Cell A says anything else then I need it to be left blank.

Thank you

**JOHN H. DAVIS** · 10-30-2013, 01:12 PM

Maybe:

Please Login or Register  to view this content.

**MM68** · 10-30-2013, 01:48 PM

Thank you so much for your response but I am a little confused.

I have attached a tester document to try and explain what I neeed.

Thanks again

**JOHN H. DAVIS** · 10-30-2013, 02:05 PM

I was a little confused as well. Still maybe.

Please Login or Register  to view this content.

Based on the data in your tester file. I set the destination to Sheet2 Columns A and B.

Copying data from one cell if another cell if a 3rd cell meets the correct criteria.

LinkBack

Thread Tools

Rate This Thread

Display

Copying data from one cell if another cell if a 3rd cell meets the correct criteria.

Re: Copying data from one cell if another cell if a 3rd cell meets the correct criteria.

Re: Copying data from one cell if another cell if a 3rd cell meets the correct criteria.

Re: Copying data from one cell if another cell if a 3rd cell meets the correct criteria.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Copying entire rows of data if a cell meets certain criteria

Copying Cell That Meets Certain Criteria

Copying Cell That Meets Certain Criteria

Excel 2007 : Copying entire rows of data if a cell meets certain criteria

[SOLVED] Get data if cell within a row meets criteria

Bookmarks

Bookmarks

Posting Permissions