Jul 11 2022 03:01 PM
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!
Jul 11 2022 03:30 PM
Solution=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.
Jul 15 2022 12:27 PM
@OliverScheurich Aha that's perfect, thank you!
Jul 11 2022 03:30 PM
Solution=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.