How can I get Excel to generate a separate new worksheet when data is inputted in row A1, etc.?

Answer 1

Hi, it sounds like you are referencing using VBA or a custom Macro. Below is some example code you can use to simulate what you have asked. To access the VBA screen in Excel just press Alt + F11 at the same time.

Example Code:

1. Private Sub Worksheet_Change(ByVal Target As Range)
2.  
3. vNew = Range("a1").Value
4. Application.EnableEvents = False
5. Application.Undo
6. vOld = Range("a1").Value
7. Range("a1").Value = vNew
8. Application.EnableEvents = True
9.  
10. If Selection.Count = 1 Then
11. If vOld <> vNew Then
12. ' Checks if cell A1 is clicked.
13. If Not Intersect(Target, Range("A1")) Is Nothing Then
14. Sheets.Add After:=ActiveSheet
15. End If
16. Else
17. End If
18. End If
19.  
20. End Sub