bbkbhattarai
New Member
- Joined
- Dec 20, 2020
- Messages
- 1
- Office Version
- 365
- 2019
- Platform
- Windows
Hello everyone,
I am new to the use of VBA and still learning on my way around. I have designed a userform, where I am to collect data based on different regions eg: London, Derby, Poole, etc (columns). I am trying to collect different varieties from each area as low, mid, high, new, old, etc (first Rows). Since multiple people will be using the userform, they might enter the first row which will have a similar value in the first row (low, mid, high, new, old) in different areas.
Can I use any formula so when anyone enters data with the same value on the row, either it will enter the data if this is the first data. If it is duplicate, it will add to the new value with the valued already which is already entered?
I hope this is not very confusing.
Thank you in advance for your time and help.
Regards
Bbk
I am new to the use of VBA and still learning on my way around. I have designed a userform, where I am to collect data based on different regions eg: London, Derby, Poole, etc (columns). I am trying to collect different varieties from each area as low, mid, high, new, old, etc (first Rows). Since multiple people will be using the userform, they might enter the first row which will have a similar value in the first row (low, mid, high, new, old) in different areas.
Can I use any formula so when anyone enters data with the same value on the row, either it will enter the data if this is the first data. If it is duplicate, it will add to the new value with the valued already which is already entered?
I hope this is not very confusing.
Thank you in advance for your time and help.
Regards
Bbk