SOLVED

# Use Autofill for multiple values in a cell

Copper Contributor

# Use Autofill for multiple values in a cell

I am printing out labels where each column is a different day # and date and each row is a different timestamp.  I'm making these for about 45 days and was wondering if there is an easy way to use the autofill function (or another method) to make it faster to fill out rather than copying and pasting each column and manually inputing the day # and date for each cell. Thanks!

2 Replies
best response confirmed by rschauer620 (Copper Contributor)
Solution

# Re: Use Autofill for multiple values in a cell

=IF(MOD(COLUMN(A:A),2)=1,CONCATENATE(A\$8," ",TEXT(\$J1,"h:mm"),CHAR(10),TEXT(A\$9,"M/TT/jjjj"),CHAR(10),"volume:"),"")

Maybe with this formula. You can enter the relevant data in rows 8 and 9 and in column J. I've entered the formula in cell A1 and copied across range A1:G6.

# Re: Use Autofill for multiple values in a cell

@OliverScheurich Aha that's perfect, thank you!

1 best response

Accepted Solutions
best response confirmed by rschauer620 (Copper Contributor)
Solution

# Re: Use Autofill for multiple values in a cell

=IF(MOD(COLUMN(A:A),2)=1,CONCATENATE(A\$8," ",TEXT(\$J1,"h:mm"),CHAR(10),TEXT(A\$9,"M/TT/jjjj"),CHAR(10),"volume:"),"")

Maybe with this formula. You can enter the relevant data in rows 8 and 9 and in column J. I've entered the formula in cell A1 and copied across range A1:G6.