Forum Discussion

VBA_ENTHU1988's avatar
VBA_ENTHU1988
Copper Contributor
May 31, 2025

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

Resources