Forum Discussion
Help with formulas
Very new to excel. Hopefully I can explain what I am trying to accomplish.
I added a photo of my screen. I am trying to make our timesheet at work more efficient.
A17 has a dropdown list of employees. My goal is to be able to have all the info from row 17 duplicate if an employee is selected.
So looking at my photo. If I have a work order number typed into cell E17 I would like that to be duplicated into cell E21 but only if there is an employee selected in dropdown cell A21
Hopefully I explained it enough to understand what I am trying to accomplish.
A photo is of very limited use. Your verbal description actually tells more. But the photo does raise questions in my mind about the whole design. SO, may I suggest -- since at this point the whole thing looks blank anyway -- that you create a version without real employee names (use Disney characters or favorite movie stars) and post the actual dummy spreadsheet. If you can't do it here, post it on OneDrive or GoogleDrive, and post a link here that grants access.
I should add, although I'm retired now I was the director of a corporate database system for employee data, including aspects such as time and pay, so I'm coming at this from a background of experience with exactly this kind of data. So I enthusiastically agree and support your desire to make the timesheet more efficient; I would suggest just from the glimpse your photo provides that a more basic redesign might be in order. But it's hard to tell without seeing it more closely, seeing a bit more how it works, what the input and output is, etc.
