Copy data from different columns based different criterion

[amit_gupta123]

Hi

I was trying to pull data from different columns and paste on another sheet. In my sample data attached, trying to reach a result where Col A & D are non-empty and that data is pasted to another sheet. Now for col B only cases with status "Rejected" to be filtered and pasted with earlier filtered data based on Col A & B

Kindly advise

Regards

 

[vletm]

amit_gupta123
Something ... in missing?
If You filter C-column as Rejected...
then there are data in A-column ... hmm?
What to copy & paste?
For me ... write Your need steps one-by-one
or
start Macro Recorder and do Your needed steps manually.

 

[amit_gupta123]

Hi

I have to
1. first filter data from Col A as Non Blanks and also Col C as non Blanks
2. Copy these filtered records and paste on sheet 2
3. Open the filter
4. Now have to filter on Col B and select "Rejected' cases
5. Copy these cases and paste in Sheet 2 beneath the data pasted in step 2

attaching the file again with input data and desired result

Regards

 

[vletm]

amit_gupta123
1) okay
2) for some reason those #1 row are from row 19
... but if 'desired'-sheet is empty or how before copy?
3) okay
4) this no match with Your writings
... seems that You've copied rows
which has Invoice and Acceptance or Invoice and empty Queue

The result is as written in #2 ... almost ... but do it matter?

 

[amit_gupta123]

Yes ...result was copied from one sheet to another

But the sequence does not matter...

 

[vletm]

amit_gupta123
You skipped few questions ...
Press [ Do It ]-button in 'desired'-sheet's header