ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   I need to automatically repeat cell (https://www.excelbanter.com/excel-worksheet-functions/75593-i-need-automatically-repeat-cell.html)

tyunika

I need to automatically repeat cell
 
I have a project I'm working on and I need to automatically repeat info from
a date of death column into a anniversary of death column without having to
copy and paste

Otto Moehrbach

I need to automatically repeat cell
 
Let's say that A2 is the first cell that contains a date of death and Column
D is the anniversary of death column.
In cell D2 put "=A2" without the quotes. Drag this formula down as far
as you need to. Anything you put in Column A will be shown in Column D as
well. HTH Otto
"tyunika" wrote in message
...
I have a project I'm working on and I need to automatically repeat info
from
a date of death column into a anniversary of death column without having
to
copy and paste





All times are GMT +1. The time now is 02:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com