Forum Discussion
CFaith
Jan 30, 2019Copper Contributor
Linked cell dependent on data from cell
I am creating an inventory workbook. I have a column asking if the product is 'active or not active' on my 'master' worksheet. I would like the product to show up on a separate (2nd) worksheet if the product is 'active.' This (2nd) worksheet is for employees to take 'active' inventory counts with. I know how to link cells, but unsure how to write a logical formula for this situation. I might be over thinking it but am at an impasse. Thanks for any and all help.
- Eva VogelSteel ContributorHi CFaith! Can you pls send a screenshot so that I could figure out. Generally you need a value to prove on a logic function such as: If(cell=12,“active“,“inactive“). First argument in () is what you would like to prove. Next argument ist the result if your cell value is „active, ELSE it’s „inactive“.
For this and other logic functions pls go to YouTube and a channel „ExcelIsFun“, it’s great! You’ll learn all tricks to get your workbook done! Greets, Eva- CFaithCopper Contributor
Hi Eva Vogel!
Let me know if you can see this okay. If not I will split it into two pictures. I've attached the workbook as well. If the product is an 'active' (see column 'W') product, I would like to see columns A-J populate on a 2nd sheet within the same workbook. I know the simple fix would just be to open a new sheet and paste the cells as a link, and filter the active column 'Yes or No' but was hoping there was another solution before going that route. Thanks for your time!!!
- Eva VogelSteel Contributor
Hold the line... i will look over it. :)