Hi,
Hope somebody can help. I have set up a spreasheet with colums K-V that have lookups, lists (lists are in columns a-L) and formulas in line 2, I want the formulas, lookups and lists choices (basically all the formatting & formulas) from line 2 to carry down the spreadsheet, however, I would like to do this w/o copying down. to avoid the #NA in the cells that haven't had their reference cell completed yet.
Is there a way to set it that when I begin a new entry in K2-and below (column K is an non-formula/non list column just a date form in the cells) that all the formatting and formulas/lists from line 1 copy into my new line?
Oh I am stuck in the land of excel 2003 for the time being.
Thanks in advance!!
Hope somebody can help. I have set up a spreasheet with colums K-V that have lookups, lists (lists are in columns a-L) and formulas in line 2, I want the formulas, lookups and lists choices (basically all the formatting & formulas) from line 2 to carry down the spreadsheet, however, I would like to do this w/o copying down. to avoid the #NA in the cells that haven't had their reference cell completed yet.
Is there a way to set it that when I begin a new entry in K2-and below (column K is an non-formula/non list column just a date form in the cells) that all the formatting and formulas/lists from line 1 copy into my new line?
Oh I am stuck in the land of excel 2003 for the time being.
Thanks in advance!!
