Adding the same info to multiple cells

**mayesdonnie** · 08-10-2011, 12:15 PM

Good morning!

I am trying to add the same info to multiple cells in Excel 2007. I am wanting 50 of each day in the year. So essentially, it would look like:

09/06/2011
09/06/2011 this repeats 50 times
09/07/2011
09/07/2011 this repeats 50 times
09/08/2011
09/08/2011 this repeats 50 times

This goes until August 31, 2012.

Is there an easier way to accomplish this than just copy the first cell and highlight the 49 cells below it and paste and repeat for the other 364 days of the year?

Thanks!

Donnie

**ChemistB** · 08-10-2011, 12:22 PM

Under your first date, you can use (assuming first date in A1)
=IF(MOD(ROW(A1),50)>0, A1,A1+1) dragged down.
You can copy > paste special>values to remove the formulas
Does that work for you?

**Richard Buttrey** · 08-10-2011, 12:22 PM

Hi,

Assuming the firs date is in A1 then in A2 and copied down

Please Login or Register  to view this content.

adjust the -1 as appropriate if you don't start on row 1. e.g. if the first date is A11 then use -11 instead

Regards

**mayesdonnie** · 08-10-2011, 12:29 PM

I copied and pasted that formula and I can accomplish the same thing by copying A1 and highlighting 50 rows down and pasting and getting that. I didn't know if there was an easy way to do it, or if I was looking at a time-consuming project here.

At row A51 I put in 09/07/11 and then copied the formula and changed the A1's to A51 and highlighted down to 100 and it showed up ok.

I guess I'm not seeing what the difference is between that and just copying and pasting until I need to change the dates next year.

Thanks!

**rosilisk** · 08-10-2011, 01:13 PM

This might be a simpler solution. Manually put your first date in the first 50 rows of the column (eg A1:A50). In the cell immediately below the first 50 rows (A51) put '=A1+1'.

Copy that formula down as far as needed.

I'm not quite sure what is confusing you about the other solution.

Does that work?

**Richard Buttrey** · 08-10-2011, 01:19 PM

Did you put the formula I gave you (amended for the row number) in A52 and copy this down for 365 * 50 rows?

Please Login or Register  to view this content.

Regards

**mayesdonnie** · 08-10-2011, 01:45 PM

Ok!! Got them all to work! Thank you. The confusion part came from me being me.... haha. Too many interruptions I guess and I was missing something here or there. Everything is good, and you all are amazing!

Thank you!