SOLVED

Formulas , Macros and VBA

%3CLINGO-SUB%20id%3D%22lingo-sub-2913073%22%20slang%3D%22en-US%22%3EFormulas%20%2C%20Macros%20and%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2913073%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20All%3C%2FP%3E%3CP%3EI%20hope%20you%20are%20having%20a%20great%20day%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Efirst%2C%20I%20would%20like%20to%20thank%20you%20all%20for%20your%20effort%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3Byour%20support%20regarding%20this%20issue%20is%20highly%20appreciated%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3E%3CSTRONG%3EDevice%20and%20OS%20platform%3C%2FSTRONG%3E%2C%20Windows%2010%26nbsp%3B%3C%2FLI%3E%3CLI%3E%3CSTRONG%3EExcel%20product%20name%20and%20version%20number%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B2013%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSTRONG%3EExcel%20file%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSTRONG%3Eyou%E2%80%99re%20working%20with%3A%26nbsp%3B%3CSTRONG%3Esample%20file%26nbsp%3B%3C%2FSTRONG%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3CU%3E%3CFONT%20color%3D%22%23FF0000%22%3ENote%3A%20The%20contained%20data%20is%20Railway%20Industry%26nbsp%3B%3C%2FFONT%3E%3C%2FU%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eneed%20insight%20on%20these%20macros%20codes%20and%20how%20they%20work.%3C%2FP%3E%3CP%3E-%20%3CU%3Eyou%20will%20find%20a%20copy%20of%20the%20file%20attached%26nbsp%3B%26nbsp%3B%3C%2FU%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EThank%20you%20in%20advance...%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%22m1.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F323044iC1A271A8D2E8CFAC%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22m1.png%22%20alt%3D%22m1%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3Em1%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%22m2.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F323045i3EE6DCD8FF3373E4%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22m2.png%22%20alt%3D%22m2%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3Em2%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%22m3.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F323046iC9498C796788C5AA%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22m3.png%22%20alt%3D%22m3%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3Em3%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%22m4.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F323047i8395545E03DF3C6A%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22m4.png%22%20alt%3D%22m4%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3Em4%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2913073%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2913261%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%20%2C%20Macros%20and%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2913261%22%20slang%3D%22en-US%22%3EMacro%3A%20Report%3CBR%20%2F%3E-%20Filters%20the%20Raw%20table%20on%20last%20two%20columns%20(%22Valid%22%20and%20True%20respectively)%3CBR%20%2F%3E-%20Sets%20outline%20level%20to%201%20to%20hide%20columns%3CBR%20%2F%3E-%20Deletes%20table%20on%20Report%20sheet%3CBR%20%2F%3E-%20Copies%20visible%20cells%20to%20Report%20sheet%3CBR%20%2F%3E-%20Removes%20filters%20on%20Raw%20sheet%3CBR%20%2F%3E-%20Unhides%20columns%3CBR%20%2F%3EMacro%3A%20Clear_Raw_Table%3A%20empties%20current%20Raw%20table%3CBR%20%2F%3EThe%20other%20macro's%20are%20not%20needed%20as%20far%20as%20I%20can%20tell.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2937860%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%20%2C%20Macros%20and%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2937860%22%20slang%3D%22en-US%22%3EThank%20you%20Jan%20Karel%20Pieterse%2C%2C%20really%20appreciate%20your%20help%3C%2FLINGO-BODY%3E
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