LinkBack URL
About LinkBacks
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 - Excel Aid
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" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.
Forum Rules (updated September 2018): please read them here.
How to use the Power Query code you've been given: help here. More about the Power suite 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)
Posting Permissions
Register To Reply
,
Bookmarks