Filter and copy based on values present in the specific column one by one, not range wise since

T

thomsonreuters

New Member
Joined
Dec 9, 2017
Messages
26
want to filter and copy based on value present from C2 cell to end of the same column and paste to a5 in sheet 2. i want to filter the criteria one by on since i need same order in result

any loop method....

can anyone pls help me

JP
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
You must log in or register to reply here.

Similar threads

C
  • Question
Microsoft Advanced Filter works only intermittently. Same exact filter in another workbook with same exact layout doesn't work.
Replies
2
Views
185
c_bro2498
C
S
  • Solved
Get a list of sequential numbers down a column with starting number 1000 on a filtered list
Replies
6
Views
284
sspatriots
S
E
  • Question
Filtering, copying and pasting
Replies
7
Views
379
Exceliscool123456789
E
E
  • Question
Filtering, copying and pasting specific values in different tabs in same spread
Replies
1
Views
358
Exceliscool123456789
E
V
  • Question
VBA copy data from workbook to another based on criteria and copy method
Replies
0
Views
347
VfTom
V

Forum statistics

Threads
1,214,940
Messages
6,122,356
Members
449,080
Latest member
Armadillos

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top