Log In
Register
Home
New Member
September 25, 2022
Offline
This is a tough one and I understand if no one can help me I looked all over the internet trying to find help but to no luck (or Atleast I couldn’t find any help)
So I have this spreadsheet I am updating to eliminate operator error when entering data. My boss wants me to make it so you have to enter all the data in the row before you can move on to the next row.
So the spreadsheet is B:M that has to have data entered, this spreadsheet is a big one so it is kinda an infinite on row numbers. The goal is imagine B1:M1 is missing data you won’t be able to begin entering data in B2:M2. I would assume this would be a VBA code, I saw some people doing similar concept to an extent but I couldn’t figure out how to alter the code to what I needed.
Trusted Members
Moderators
Power BI
January 31, 2022
Offline
Hi,
Initially, I hadn't paid attention to your question as it referred to VBA, but perhaps you can live with a solution that uses data validation. The attached file contains an example where the outlined area contains the following validation rule.
=COUNTA($B1:$M1)=12
B1:M1 should have a header of som kind, otherwise you can't start entering somethin on row 2.
See if this could work for you.
Riny
1 Guest(s)
