| [10:46] System: Kazilla
has joined the chat |
| [10:46] Kazilla:
cell A2 = 1, if cell A2 >= 1, I want to add a line on a new worksheet that tracks misc. information. IF that number changes to 2, I want to add a new line under the originally created information from when that cell was a 1. Any ideas? |
| [10:58] System: Kazilla
has left the chat |
| [13:22] System: WetWired
has joined the chat |
| [13:22] WetWired:
If you need to do this on a sheet containing source data, you'll need to use VBA. If the second sheet just changes based on data from the other, use a hidden column that tracks the source row for each output row (add 1 or 0 depending on whether you need an extra row). Then, use the offset function to select the correct data based on the counting column |
| [13:24] System: WetWired
has left the chat |
| [20:33] System: Kazilla
has joined the chat |
| [20:41] System: Kazilla
has left the chat |
