Hi
I wish to clear linked formula results, for example in cells B, C, D, E, F2 when there is a new entry in cell A2
When a new name is entered into cell A2, I want to clear all results from the adjacent cells
Hi
I wish to clear linked formula results, for example in cells B, C, D, E, F2 when there is a new entry in cell A2
When a new name is entered into cell A2, I want to clear all results from the adjacent cells
Last edited by SJTBrown; 06-04-2022 at 08:58 AM.
what are the formulas?
You probably need VBA for this.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Administrative Note:
Welcome to the forum.
Members will tailor the solutions they offer to the version (NOT a release number like 2205) of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi Dave
there are 2 linked formula, first is to calculate the time difference in minutes and hours between 2 cells, then the results of that are linked to a nested If formula to calculate a price base on minutes and hours
Please update your profile as I requested. Thanks.
There are instructions at the top of the page explaining how to attach your sample workbook.
A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.
Thank you all for your help
I eventually sorted the issue, I created a VBA to clear cells in a row, and attached it to a specific cell so that when any change happened in that cell in ran the macros
Please don't ignore the request to update your profile!!!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks