How to add a single value in multiple cells of excel?

inaaya.sami

New Member
Hi,

Can anyone help me on how to add a single value present in data item to multiple cells in excel?
Example: I have 30/02/2019 value in a data item, i would like to write this value in cells from A1 to A5 in excel.

Thanks.
 

gsaideepak

New Member
You can use "Go to next empty cell down" action from the Excel VBO and have a loop with the max counter that equals the number of cells that you want the data to be entered.
 
Top