How do I create a formula or Macro that will automatically collect entered data according to serial

%3CLINGO-SUB%20id%3D%22lingo-sub-2415821%22%20slang%3D%22en-US%22%3EHow%20do%20I%20create%20a%20formula%20or%20Macro%20that%20will%20automatically%20collect%20entered%20data%20according%20to%20serial%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2415821%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%3C%2FP%3E%3CP%3EHow%20do%20I%20create%20a%20formula%20or%20Macro%20that%20will%20automatically%20collect%20entered%20data%20according%20to%20serial%20number%2C%20date%20%26amp%3B%20time%2C%20and%20description%20in%20order%20and%20place%20them%20chronologically%20at%20the%20bottom%20of%20the%20document%3F%20Also%2C%20is%20there%20a%20formula%20or%20IF%20factor%20I%20can%20add%20to%20a%20line%20that%20will%20allow%20a%20blank%20cell%20to%20clear%20out%20another%20cell%20in%20another%20location%20of%20the%20document%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2415821%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hello all,

How do I create a formula or Macro that will automatically collect entered data according to serial number, date & time, and description in order and place them chronologically at the bottom of the document? Also, is there a formula or IF factor I can add to a line that will allow a blank cell to clear out another cell in another location of the document?

0 Replies