Forum Discussion
Excel formula/function help! Please
Hello! I have: 2 worksheets in same work book (worksheet Bill & worksheet Casey) each worksheet has Col A - client #s and Col D - status Here's what I need to do.... I hope someone can help. Ne...
HI
If you are only updating Casey and want bills information to mimic exactly what is on her sheet, Vlookup the client number from both cells. However, you will need to refresh the sheet each time you make an update to reactivate the formula. If you take the time to go to each cell and type =CaseyC2 etc, you can avoid the refresh. If it is a regular update and/or you add more clients over time, I would take the time to type the =CaseyCell#.
Hope that helps