Forum Discussion

FGExcel's avatar
FGExcel
Copper Contributor
Nov 28, 2019

Selection Criteria using excel

Hi,

 

I have attached another workbook.

My Questions are:-
1) There are many different tabs of spreadsheets on the mall, how can I select any one selection, e.g. Machine status, version or location and it still view at the Masterlist spreadsheet?


Any suggestions on excel without VBA can work? If VBA coding, could you assists me how it should work?

 

Hope to hear from you soon.

 

Thanks.

admin
excel
Excel for web
Formulas and Functions
Macros and VBA
office 365
power bi
training

1 Reply

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Nov 29, 2019
    - Copy the headings frmo the first mall tab's table, paste on main tab
    - Copy each tab's table without the heading, paste into the main tab (underneath each other)
    - Get rid of all the mall tabs
    - Now just filter the main tab's table on the location column.

Resources