I’ve arrange a Google Sheets template for coming into information into a number of columns and rows, per particular person tasks. I’ve additionally created one other Google Sheets “importrange” template, that is use to breed a sub-set of my data-entry sheets right into a separate “importrange” sheet — in order that I can share it with others.
I exploit the “Type vary” perform in my important information entry spreadsheet to neatly arrange my information within the “importrange” sheet, primarily based on three column values (e.g., Column A -> Company [sort A – Z] , Column B -> Sub-Company [sort A – Z] , Column C -> Date [sort Z – A] ).
I am questioning how I can do the next:
-Arrange some sort of often functioning “Type vary” perform in my information entry spreadsheet. (Ideally, I might like to use the identical “Type vary” perform to my template file.) It appears like I might should arrange and run “Type vary” each time I enter new information into my important information entry spreadsheet in order that it seems in my “importrange” sheet.
-If doable, create a row, or some sort of definition, between each new worth entered in considered one of my columns. Particularly, I might like there to be some sort of row house / definition between each new Sub-Company, that are values that I enter in Column B of my spreadsheet.
-Make sure that the textual content formatting contained in considered one of my cells in my information entry spreadsheet can carry over to my “importrange” sheet.
-Much less pressing… Assign font / background coloration formatting for values in two columns that may be utilized to the principle spreadsheet — or no less than my “importrange” sheet.