So I'm not even totally sure how to describe what I want to do, so I'm not even sure how I should look it up. I apologize if this has been answered somewhere else.
Let me add a picture here and try and explain what I want to do, if it's even possible.
So I've gotta do these time cards at work. I have four different cards just like this one here. I've already got a formula setup in the far right column that totals all my time in the duration column if it matches the job column. So if the Job is Grounds, it adds all those together for me.
What I'd like to be able to do, if possible, is when I add something to the Job column, it populates in that right hand column. So If I add grounds on the left, it'll show up on the right. if I put in a unit number, same thing, if I put in that I was working in he office, ditto. Just whatever I put in C32:C55, also goes into G32:G55.
I've still got to manually go into my SUMIF and add the name there I suppose, I doubt I can make that auto populate as well, but this would save me some time in the long run. Most of the time I work on these it's from my phone and the less typing I have to do there the better.
Thanks in advance for any help here. I appreciate it. It's been ages since I put a lot of time into excel and I don't remember most of what I was taught and picked up.