Related:
- Auto Populating Spreadsheets
- Grand theft auto v free download no verification for pc - Download - Action and adventure
- Facebook auto refresh - Guide
- Grand theft auto iv download apk for pc - Download - Action and adventure
- Auto redial samsung - Guide
- Nvidia drivers auto detect - Guide
1 response
Welcome. Thank you for stopping by and asking the pros. I am sorry to be the one to let you know that we HELP, we do not provide turn key solutions. The reason this is, is we will spend the time and complete the "macro" code, only to be told that the scope has expanded, and there is a change to be made!
Here is a good start, then post back with your code when you get stuck. This solution can be solved with a bunch of CASCADING "if"'s. What are those? They are a series of If statements that change based on the previous cell. So point all of the ifs at the cell in fron tof it!
The syntax for IF is as follows:
=IF(Logic_test,True,False)
So, with that known, we can write something like:
On Sheet 1:
=IF(A4="x",1500)
Then on Sheet 2:
=IF(Sheet1!B4=1500,"Lamp Sold")
Now put an "x" in Cell A4, of Sheet 1.
Have FUN!
I have said it once, I will say it again. IT!
Here is a good start, then post back with your code when you get stuck. This solution can be solved with a bunch of CASCADING "if"'s. What are those? They are a series of If statements that change based on the previous cell. So point all of the ifs at the cell in fron tof it!
The syntax for IF is as follows:
=IF(Logic_test,True,False)
So, with that known, we can write something like:
On Sheet 1:
=IF(A4="x",1500)
Then on Sheet 2:
=IF(Sheet1!B4=1500,"Lamp Sold")
Now put an "x" in Cell A4, of Sheet 1.
Have FUN!
I have said it once, I will say it again. IT!
