Any suggestions on the best way to append data to a sample file such that we can create the date in Yellow in the same date format as the previous cells.
Hi @mkiefer1
Please check this out. I tried to generate dynamically the months - up to current one. Hope this is what you are looking for.
Please see attached. It is pretty lengthy but working. Perhaps there are more elegant ways to achieve the same goal 🙂
This is great thanks @ christine_assaad.
Can i ask also - what would be the best way to lay in data underneath that new field that was created (July 20th). So every month there will be new numbers that drop in - so for example, the attached 'new data' would need to align with the new column that was created so that jul 20 would read:
Awesome thanks @Christine_assaad. I can tweak this slightly to get what I'm looking for - thanks again!
