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

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
You must log in or register to reply here.

Similar threads

M
  • Question
Filter Array Based On Two Criteria
Replies
1
Views
267
SunnyAlv
SunnyAlv
B
  • Question
Paste results of Filter Function in place, or in separate sheet
Replies
0
Views
111
bertible
B
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
J
  • Question
Marking Top 10 in Criteria List
Replies
1
Views
49
Jezzzza
J
K
  • Question
Help with VB Code to copy workbook
Replies
0
Views
156
kizzie37
K

Forum statistics

Threads
1,214,971
Messages
6,122,517
Members
449,088
Latest member
RandomExceller01

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