ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Refresh a cell that contains a formula (https://www.excelbanter.com/excel-programming/412787-refresh-cell-contains-formula.html)

Aaron

Refresh a cell that contains a formula
 
I was given a spreadsheet with 2 worksheets. One worksheet contains the data
and the other is an interface called Quick Search. On the Quick Search sheet
there is a combo box pulling informormation from a column in the second
sheet. When the selection in the combo box changes it updates a
corresponding number in a hidden cell Q2. In another cell R11 a VLOOPKUP
formula exists to pull information and place it in another cell to view the
data.

What I need is when this combo box changes or the cell Q2 is updated with
the corresponding number, the VLOOKUP formula does not refresh it's data in
it's display fields. How can I best accomplish this?


All times are GMT +1. The time now is 01:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com