Forum Discussion
Solved
Duplicating cell value on another sheet
Hello, I am pretty new to excel and this community. I have some knowledge of doing formulas, but all pretty basic. So, what I would like to do is this: If the value of cell "i2" in "sheet2" is g...
You are welcome. After the formulas are entered in cells A14 and K14 you can drag them down. The results are then displayed in ranges A14:A29 and K14:K29 for example as shown in the attached screenshot and file.
Thank you! So the formulas work and will add the cell values into sheet 1, but only into Row 14. What it's doing is only taking the first value greater than 0 and adding it to Row 14. If any other values are greater than 0, they do not show up in Sheet 1 unless I erase the first value. Is there a way to have them added to the rows below when I have multiple values above 0?
Thank you for your help!
You are welcome. After the formulas are entered in cells A14 and K14 you can drag them down. The results are then displayed in ranges A14:A29 and K14:K29 for example as shown in the attached screenshot and file.
- Thank you for your help! It works great!!