Excel worksheet
 

Is there a formula, or function that will,
In a spreat sheet, if there is a section in the sheet that does not pertain
to some of the users of the spreadsheet, therefore left blank (or otherwise
formulated, if there is one) is there a way to delete the entire row(s) in
the sheet? (other than the non-experienced users to delete rows manually).

Excel worksheet
 

On Jul 31, 1:56 pm, boschuster50
wrote:
Is there a formula, or function that will,
In a spreat sheet, if there is a section in the sheet that does not pertain
to some of the users of the spreadsheet, therefore left blank (or otherwise
formulated, if there is one) is there a way to delete the entire row(s) in
the sheet? (other than the non-experienced users to delete rows manually).

No formula or function can delete anything. And if you delete a row
because "John" is looking at it, how will you get it back when you
look at the workbook, again?

Sounds like you need to use Protect Sheet, Hide, Lock Cell and some
other security methods if some people are not allowed to see
everything. Although you should know that Excel's security is not very
good against high-end users.

Another alternative is probably to use VBA to Hide (not delete)
certain data based on the user that opens the file. At least, I'm
assuming VBA can reference the user. But I couldn't write that for
you, need someone a little more advanced.

Excel worksheet
 

It's not that the user's are not supposed to see information, it is that the
user's do not need all of the rows included in the spread sheet. I am asking
for another gentleman in the office, personally I don't see the difficulty in
deleting rows.
Thanks for your response.

"Spiky" wrote:

On Jul 31, 1:56 pm, boschuster50
wrote:
Is there a formula, or function that will,
In a spreat sheet, if there is a section in the sheet that does not pertain
to some of the users of the spreadsheet, therefore left blank (or otherwise
formulated, if there is one) is there a way to delete the entire row(s) in
the sheet? (other than the non-experienced users to delete rows manually).

No formula or function can delete anything. And if you delete a row
because "John" is looking at it, how will you get it back when you
look at the workbook, again?

Sounds like you need to use Protect Sheet, Hide, Lock Cell and some
other security methods if some people are not allowed to see
everything. Although you should know that Excel's security is not very
good against high-end users.

Another alternative is probably to use VBA to Hide (not delete)
certain data based on the user that opens the file. At least, I'm
assuming VBA can reference the user. But I couldn't write that for
you, need someone a little more advanced.