Allow User to Edit Ranges

C

crapit

Any better way to input the range for a 30 spreadsheet???

a8:j20 , m8:p20 , r8:s20
a22:j34 , m22:p34 , m22:p34
a36:j48 , m36:p48 , m36:p48
a50:j62 , m50:p62 , m50:p62
a64:j76 , m64:p76 , m64:p76
a78:j90 , m78:p90 , m78:p90
a92:j104 , m92:p104 , m92:p104
and so on ....
 
S

Shane Devenshire

Hi,

Are you asking how to assign 30 different user to the ranges you listed or
are you saying you want to give one or more users access to all 30 ranges?
Or are you talking about 30 spreadsheet?
 
C

crapit

3 spreadsheet
Shane Devenshire said:
Hi,

Are you asking how to assign 30 different user to the ranges you listed or
are you saying you want to give one or more users access to all 30 ranges?
Or are you talking about 30 spreadsheet?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire
Click to expand...
 
C

crapit

Do I have to key in line by line in the "Refer to Cells" i.e total 20 line
for 30 spreadsheets
 
Top