How to duplicate the Row with next month

1

I want to duplicate the row with button action and I want all the data to be copied as it is and date should of next month. Ex if I have a date of 24th march and when I click on the duplicate button then the date should be of 24th April.

Please find the example sheet below

Thanks!

2

hi @Tanuj_Verma ,
Thanks for adding a sample doc, that works great

image
image1405×750 66.7 KB

what I did was this:

  • I added an extra column with the next month
  • I used this value in the function you already had

This is the function in the button

AddRow(Table,
  Table.Name, thisRow.Name,
  Table.Cost, thisRow.Cost,
  Table.TheDate,thisRow.[next month]
  )

To get the next date I used:

Date
(thisRow.TheDate.Year(),
thisRow.TheDate.Month()+1,
thisRow.TheDate.Day())

Hope it helps!
Christiaan

1 Like
3

Thank you so much! I added this formula in button and its working like a charm for me.

4

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