PP3321
Active Member
Dear Chandoo community,
I want to ask your opinions or experience of switching to Access from Excel.
I want to know what was the main reason for switch.
Here is my situation:
1)Every day I have been adding 100 rows of data to excels manually
2)Now the worksheet contains 10,000 rows.
3)For duplicated values, I have Conditional Formating
4)I cannot enter values that are available in another worksheet.
There is vlookup to check
I am beginning to think I should start using Access as it seems to be less prone to error...
*I saw this post to understand advantage and disadvantge of Excel
https://chandoo.org/forum/threads/so-what-is-excel.33984/#post-202480
Thanking you in advance...
I want to ask your opinions or experience of switching to Access from Excel.
I want to know what was the main reason for switch.
Here is my situation:
1)Every day I have been adding 100 rows of data to excels manually
2)Now the worksheet contains 10,000 rows.
3)For duplicated values, I have Conditional Formating
4)I cannot enter values that are available in another worksheet.
There is vlookup to check
I am beginning to think I should start using Access as it seems to be less prone to error...
*I saw this post to understand advantage and disadvantge of Excel
https://chandoo.org/forum/threads/so-what-is-excel.33984/#post-202480
Thanking you in advance...