Forum Discussion
Carol Martines
Dec 13, 2018Copper Contributor
copiare celle più volte
Ciao a tutti, come si fa a copiare un tot numero di celle in colonna per 30 volte ? Ho la domanda di un giorno tipo al mese ma per darla come input ad un codice che sto usando mi serve averla gior...
Arul Tresoldi
Dec 13, 2018Iron Contributor
"Hi everybody,
how to copy some cells in a column for 30 times exactly?
I have a "question of the day" each month, but I have to give it as an input for a code I'm using, so I need to have it each day even if it's the same for all the days of the month. I have to do this for the whole year. How can I copy 30/31/28 times that column composed of 24 hours and 24 values?"
I'm Italian, so I did not used a translator.
Despite I read your text as a mothertongue, I did not get what you need.
If you need to have a certain value repeated for the whole day (depending on the month) you can use a VLOOKUP formula (CERCA.VERT in Italian), referring to a simplified table with only the month and the value you have to call.