LUIS FREUND
asked on
ENTER A NUMBER INTO A CELL AND POPULATE OTHER CELLS BASED ON WHAT WAS ENTERED IN EXCEL PART 2
This has been solved once before and it works amazingly but now I have If condition that I want to incorporate in this. Here is the previous link that this question was solved.
https://www.experts-exchange.com/questions/29013166/Enter-a-number-into-a-cell-and-populate-other-cells-based-on-what-was-entered-in-Excel.html
Ok...here we go. I've added columns D and E in the Data Tab that will drive an If condition. For example - Currently when you enter the RFQ number on the CPC tab it will populate against the PN and Rev (columns B and C) from the data tab but if there is a something in Columns D and E I would want that in the PN and Rev...essentially replacing what's in columns B and C.
Basically if Column B is different than Column D than populate with what is in D on the CPC Tab PN. IF Column B is the same as column D than populate with what is in column B.
Basically if Column C is different than Column E than populate with what is in E on the CPC Tab Rev. IF Column C is the same as column E than populate with what is in column C.
Those are the only areas that would change....everything else would be same. Hope this makes since. I'm guessing it would be the formulas in columns B and C of the CPC tab that needs modifying I hope. See attachment
C--Users-lfreund-Desktop-RFQ-XXXX-C.xlsm
https://www.experts-exchange.com/questions/29013166/Enter-a-number-into-a-cell-and-populate-other-cells-based-on-what-was-entered-in-Excel.html
Ok...here we go. I've added columns D and E in the Data Tab that will drive an If condition. For example - Currently when you enter the RFQ number on the CPC tab it will populate against the PN and Rev (columns B and C) from the data tab but if there is a something in Columns D and E I would want that in the PN and Rev...essentially replacing what's in columns B and C.
Basically if Column B is different than Column D than populate with what is in D on the CPC Tab PN. IF Column B is the same as column D than populate with what is in column B.
Basically if Column C is different than Column E than populate with what is in E on the CPC Tab Rev. IF Column C is the same as column E than populate with what is in column C.
Those are the only areas that would change....everything else would be same. Hope this makes since. I'm guessing it would be the formulas in columns B and C of the CPC tab that needs modifying I hope. See attachment
C--Users-lfreund-Desktop-RFQ-XXXX-C.xlsm
You said: I've added columns D and E in the Data Tab
I presume you posted the workbook that you added the 2 columns right ? and this without changing any of the formulas.
If above is correct then could you please post the workbook that was working 'without' the addition of the 2 columns ?
gowflow
I presume you posted the workbook that you added the 2 columns right ? and this without changing any of the formulas.
If above is correct then could you please post the workbook that was working 'without' the addition of the 2 columns ?
gowflow
ASKER
Hi Roy Cox.....I'm open for efficiency and streamlining.....
ASKER
Hi GowFlow.....it's basically the same workbook and formulas.......right now with the addition of columns D and E, that data is not doing anything.
Also the original WB that was created from resides in the link in the body of my request above.
Also the original WB that was created from resides in the link in the body of my request above.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you so much Mr. Shums!
I'm not entirely sure what you want changing in the formulas, but all those Array Formulas will impact on the performance of the workbook.