V.B.A.02
10-30-2017, 01:24 PM
Hello,
I am looking Some Excel help related to data tables in Excel....
I have a data table (say, MasterTable) in one Sheet in a workbook and another data table (say, SubTable) in another sheet in same workbook. Both tables have same columns.
SubTable contains all the data from MasterTable which has Status as "Active" in Status Column (This column contains values as "Active" and "InActive" only).
Data is added or edited in MasterTable only. I need SubTable to be refreshed or updated either on some button click or as soon as MasterTable is updated and saved.
I think I basically want some select query to run to show all fields where status is active.
any help is appreciated.
Thanks,
I am looking Some Excel help related to data tables in Excel....
I have a data table (say, MasterTable) in one Sheet in a workbook and another data table (say, SubTable) in another sheet in same workbook. Both tables have same columns.
SubTable contains all the data from MasterTable which has Status as "Active" in Status Column (This column contains values as "Active" and "InActive" only).
Data is added or edited in MasterTable only. I need SubTable to be refreshed or updated either on some button click or as soon as MasterTable is updated and saved.
I think I basically want some select query to run to show all fields where status is active.
any help is appreciated.
Thanks,