instinct can not excel in Chinese automatically filled according to the date of the change to a different location?
I want to fix a cell, type a text.According to the date of the change, automatically fill to a different cell.For example:I am on Dec.13 in cell A1 enter the 123, he will automatically fill the cells B1, to December 14, I also enter 456 in cell A1, he is automatically filled into the cell B2
, this really heard of.Ruicheng old masters seem foolish not very realistic, if landlord to December 14, when, as in cell A1 enter the 124, will automatically fill to the b2's what did?
can use the Access database
should be able to, but you have certain restrictions, such as:B1 = if (A1 = 400, A1, “”)
Tools / Options / re-calculation, select the “iterative calculation”.B1 = IF (TEXT (NOW (), “m on d day”) = “December” & ROW (A13) & “days”, A $ 1, B1) copied down to the B2
Leave a Reply
You must be logged in to post a comment.