Claire Jackson
Board Regular
- Joined
- Jun 30, 2020
- Messages
- 77
- Office Version
- 2016
- Platform
- Windows
Hi,
I have an excel spreadsheet that pulls data from my outlook using Zapier which adds the data to the end row of a used range. Basically I am unable to add a formula for the new data before it's added because Zapier will add the new data AFTER the formula. Anyway, what I need is some coding which will add specific data to a cell if that last cell is added (hope this makes sense).
e.g. Column A, row 44 gets populated with data from Zapier to the last row then I want to copy the data from Cell C1 into Column C row 44, and next time it would automatically do the same in row 45 etc. etc.
I have an excel spreadsheet that pulls data from my outlook using Zapier which adds the data to the end row of a used range. Basically I am unable to add a formula for the new data before it's added because Zapier will add the new data AFTER the formula. Anyway, what I need is some coding which will add specific data to a cell if that last cell is added (hope this makes sense).
e.g. Column A, row 44 gets populated with data from Zapier to the last row then I want to copy the data from Cell C1 into Column C row 44, and next time it would automatically do the same in row 45 etc. etc.