Forum Discussion
VBA_ENTHU1988
May 31, 2025Copper Contributor
Match Row position for multiple rows of same Metric
- I have around 30000 rows in my excel, which values for
- multiple metrics
- for multiple months
- Rows for 01 month for 01 metric has Headers as 01 rows and values remaining
- there are around 150 columns
- Example as in below table metric ABC in DEC 2024 has 5 column whereas in JAN it can have 6 column or 4 columns and so on
- We need to match COLUMN_TYP =H for each metric if
- for ABC DEC and JAN it would match but for FEB Cost is in Column G as compared to DEC, JAN it was in Column H
- we need to check for each file compare header
Kindly hep if we can have some sort of VBA scripts
No RepliesBe the first to reply