Insert row that once data from column A to W is filled in, it moves the row down? I saw something about adding a button to manually make it shift with developer insert. That would be ok, but it seems like its conflicting with the columns I have as drop down options.
Using Excel desktop app version 2606
I'm self taught with excel, I'm trying to make a sheet for tracking jobs for work. I'm not even sure if this is possible as I've seen conflicting things online. Is it possible to lock my 7th row as a input field and when I complete all columns A to W it will shift the row down? I did make tables for some of the columns to have drop downs, maybe I'm over complicating things and stuff is conflicting. I was trying to have AI walk me through some options. one was inserting a table but its not letting me.
In short the row of things I want tracked, A through W. Would greatly prefer if I could keep drop down options for some of them. Biggest thing I would love to have is the first row be empty until I fill all the fields of data out, then it shifts the row down. I have a column of a "setup date" that I will sort the list by, All I want is to be able to have a input field and not have to go to the bottom of the list to add stuff every time.
[link] [comments]
Want to read more?
Check out the full article on the original site