hello,
I am looking to create a sheet that automatically updates itself in alphabetical order, when we enter any data.
here is the case:
- I've 30 secondary sheets and 1 master sheet
-----------------------------------------------------sheets detail-----------------------------
Master Sheet detail:
Secondary sheets detail:
I want that when user enters a new Name in master sheet and presses "Enter" then:-
Column A of master sheet should automatically arrange itself in ascending order, along with all the corresponding data in column B to AM
since secondary sheet's column A is also linked with master sheet, so they should also be updated along with their data in corresponding columns i.e B to I
thanks in advance
I am looking to create a sheet that automatically updates itself in alphabetical order, when we enter any data.
here is the case:
- I've 30 secondary sheets and 1 master sheet
-----------------------------------------------------sheets detail-----------------------------
Master Sheet detail:
- master sheet's column A contains name from A3 to A100 (user can edit this column)
- Column B to to AM contains data corresponding to each name in column A
Secondary sheets detail:
- column A contains name from A3 to A100 which are linked to master's column A (means any change in Master sheets' column A will change this column).................. (user cannot edit this column)
- column B to I contains corresponding data and summary of these columns are reflected in master sheet's column B to AE (Rest of the columns of master sheet i.e from AF to AM is used for further calculations )
I want that when user enters a new Name in master sheet and presses "Enter" then:-
Column A of master sheet should automatically arrange itself in ascending order, along with all the corresponding data in column B to AM
since secondary sheet's column A is also linked with master sheet, so they should also be updated along with their data in corresponding columns i.e B to I
thanks in advance