| [11:46] System: Kazilla
has joined the chat |
| [11: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? |
| [11:58] System: Kazilla
has left the chat |
| [14:22] System: WetWired
has joined the chat |
| [14: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 |
| [14:24] System: WetWired
has left the chat |
| [21:33] System: Kazilla
has joined the chat |
| [21:41] System: Kazilla
has left the chat |
