Auto fill range by copying a date instead of creating a data series

Hi everybody,

I need to fill a column with one specific date. When I use auto fill activity, it fills in a data series even if I provide the first two “source cells” with the specific date.

Example what I get:
01.04.2020
01.04.2021
01.04.2022

Example what I need:
01.04.2020
01.04.2020
01.04.2020

Does anybody have an idea how to do this?
Thank you!

You can use Read Range to read in the data, then use a For Each Row activity to set the value of each cell to the specific value you want. Then use the Write Range activity to set the data in the Excel workbook.

Thanks for your suggestion.
I already thought about this, but I need to do this for around 250 000 rows. I think this will require a lot of time.
Is there any other way to do this?

Have you thought about creating a DataTable with 250,000 rows and then just doing a write-range?

Yes, but then I would have to use for each as well and add a new row with the value 250 times. Or is there another way to create a data table with 250 rows and assign the same value to all rows “at the same time”?

Thank you :slight_smile:

Hi @silvia93, I had the same problem but at the end I used read cell activity to read cell value and then write cell activity where i used the range for example “A1:A10000”

Screenshot_6

1 Like

Hi salvatore.quimi,
thanks for your answer. That’s a great solution.

Anyway, I already solved it with this workaround:

  1. write cell activity, e.g. cell B2.
  2. write formula “=$B$2” in cell B3.
  3. Auto Fill Range with source cell B3.
2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.