SOLVED

Formulas , Macros and VBA

Occasional Contributor

Dear All

I hope you are having a great day 

 

first, I would like to thank you all for your effort 

 

 your support regarding this issue is highly appreciated 

 

  • Device and OS platform, Windows 10 
  • Excel product name and version number 2013
  • Excel file you’re working with: sample file 

 

Note: The contained data is Railway Industry 

 

need insight on these macros codes and how they work.

- you will find a copy of the file attached  

 

 

Thank you in advance... 

 

 

m1m1m2m2m3m3m4m4

 

 

2 Replies
best response confirmed by style3body (Occasional Contributor)
Solution
Macro: Report
- Filters the Raw table on last two columns ("Valid" and True respectively)
- Sets outline level to 1 to hide columns
- Deletes table on Report sheet
- Copies visible cells to Report sheet
- Removes filters on Raw sheet
- Unhides columns
Macro: Clear_Raw_Table: empties current Raw table
The other macro's are not needed as far as I can tell.
Thank you Jan Karel Pieterse,, really appreciate your help