Restricting Cells

Carly23

New Member
Joined
Jun 28, 2007
Messages
27
Does anyone know if it is possible to restrict cells so they have to be filled in?

For instance, I have data that is filled in from A8:L8. If A8 is filled in, I would like excel to require that B8, C8, etc. be filled in as well. Then the same for A9 and so on. Is this possible?

Thanks for any help!
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

dave3009

Well-known Member
Joined
Jun 23, 2006
Messages
7,128
Office Version
  1. 365
  2. 2021
Platform
  1. Windows
  2. Mobile
  3. Web
Can you provide more info on the type of data you wish to store.

Are you going to allow blank cells? How versed are you in VBA?

KR


Dave
 

Carly23

New Member
Joined
Jun 28, 2007
Messages
27
I have drop down menus to select for each cell. Each individual record is to be stored horizontally (A-L). The data ranges from names to dates to times. I want to make sure each category of data is filled in (A-L). If A is filled in, I don't want any blank cells from B-L. I hope I answered your question. Sorry if I repeated myself at all.

I am slightly familiar with VBA.

Thanks!
 

Forum statistics

Threads
1,181,412
Messages
5,929,782
Members
436,689
Latest member
IbraheemWard

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top