Notifications
Clear all
VBA & Macros
2
Posts
2
Users
0
Reactions
74
Views
Topic starter
Hi, all
I am creating a salary excel file
How to select or writ sheet no (month) and select or write staff code display data The information of the selected staff from the desired page is displayed in this page
thank you
Posted : 10/10/2021 5:02 am
Splitting data across multiple sheets is a bad idea, you will then need to aggregate data back in order to create reports.
Best is to insert data into one sheet only, you will have access to much more powerful tools to view reports, see sample attached. All you have to do is to add Month and Year column to the data structure you have, no need to separate into sheets.
You can even use a simple form to enter data, see an example here: https://www.myonlinetraininghub.com/excel-forms
Posted : 13/10/2021 12:15 am
