VBA Columns stacking and unique filter.

R

RyanNguyen

New Member
Joined
Nov 1, 2021
Messages
1
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Hello, I have come across an issue stacking and filter unique multiple columns in excel 2019. I have 2 columns in "CID" tab from column range C22:C500 and the other is in column range F22:F500 that need to be stacked up to last non empty cell in "BOM" tab column H2 and down. Also, I would filter out the unique data in both of the columns C and F in "CID" tab before stacking over the "BOM" tab.
I would greatly appreciate if you could help me with a VBA command button
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
You must log in or register to reply here.

Similar threads

S
  • Solved
VSTACK function in a macro to stack multiple table columns in a different table
Replies
2
Views
220
sspatriots
S
S
  • Question
Dynamic stacked bar chart, with variable x-axis and categorical variables
Replies
2
Views
1K
SYKEMAKAVELI
S
A
  • Question
Creating A Validation List From Unique Values in A Column (Filtered and unfiltered)
Replies
3
Views
157
RoryA
RoryA
C
  • Solved
Stack columns but carry row data
Replies
5
Views
485
COWater
C
T
  • Question
Multiple filters on filtered list
Replies
1
Views
184
Cubist
C

Forum statistics

Threads
1,214,649
Messages
6,120,728
Members
448,987
Latest member
marion_davis

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