Automated copy without comments and certain rows

Perhha

New Member
Joined
Sep 10, 2019
Messages
1
Hello!

I have a simple excel file from which I'd like to share just certain rows and no comments with my colleagues in a separate file stored on a common file area. I'm thinking about creating a copy that is automatically updated at least daily in which some of the rows and all of the comments/notes are removed. I cannot seem to find a good way of doing this, any ideas?

Example:
My document has 50 rows and 400 columns with comments/notes every here and there. I need to share a copy (stored on a different drive) but I only want others to see rows 1-30 and no comments. The copy needs to be updated at least daily. How do I do this?

/Perhha
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
18,451
Office Version
2013
Platform
Windows
Copies sheet2 to the current directory and names it Backup

Code:
Sub MM1()
Rows("31:50").Copy Sheets("Sheet2").Range("A1")
Sheets("Sheet2").SaveAs ThisWorkbook.Path & "\Backup" & ".xls"
End Sub
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,090,481
Messages
5,414,799
Members
403,543
Latest member
Tonkytonk

This Week's Hot Topics

Top