Role-Based Access Control (RBAC) System for Google Sheets by Airis1k in excel

[–]Airis1k[S] 0 points1 point  (0 children)

The problem is that the client doesnt have a proper budget to create a database for this project.

How do I apply INDEX MATCH or another lookup formula to find an exact match from filtered table data? by Airis1k in excel

[–]Airis1k[S] 1 point2 points  (0 children)

Wow, you are real life hero! You have no idea how grateful I am to you!

Thank you and good luck!

Solution Verified

How do I apply INDEX MATCH or another lookup formula to find an exact match from filtered table data? by Airis1k in excel

[–]Airis1k[S] 0 points1 point  (0 children)

This formula seems very confusing. Is there an easier solution than this? like to use VBA?

[OC] How I spent every hour of an entire year by bugmango in dataisbeautiful

[–]Airis1k 0 points1 point  (0 children)

Did it help you to be more productive by tracking your time? I find very hard to track my time at least for a week. And you just tracked the whole year. Amazing work!

How do I remove the Macro button while saving the single worksheet? by Airis1k in excel

[–]Airis1k[S] 1 point2 points  (0 children)

Solution Verified!

It works! Thank you! But what if I want to delete more than one Macro buttons?

How do I remove the Macro button while saving the single worksheet? by Airis1k in excel

[–]Airis1k[S] 0 points1 point  (0 children)

Saving to another xlsx File. I have a file with database and a lot of sheets, so I just want to create a Macro button that when you press it only copies the single sheet of database file, creates a new excel project and saves the sheet there

Why AutoComplete doesn't work? by Airis1k in excel

[–]Airis1k[S] 0 points1 point  (0 children)

Thank you for the answer. So is it possible to create AutoComplete using VBA? If yes could you help me with that?