Need Additional Macro Code to clear out data from secondary Page after data has been chang

I received help from here a while back regarding macro code (PREVIOUS THREAD => macro if data in column a = set word to insert that column into sheet 2 or 3 based on word). I am having a problem now where if data is changed in the main spreadsheet the secondary spreadsheets are retaining that formula rather than clearing it from the previous secondary and putting it to a new secondary. Below is the code that is being used in the document.

Please Login or Register  to view this content.

Hello ExcelBeginner326,

What changes have you made to the workbook?

Did you change any names?

Did you add or delete any sheets?

Did you change any formulas?

Sorry, I copied from the wrong part form the old thread. Below is from the latest document that we have been using. I did also add conditional formatting so the % complete would color code based on what value is entered.

It is a working task list, so as projects are completed, they are being deleted or replaced with new projects (sometimes by different departments - this is where the problem occurs), and new projects are being added to the end of the main spreadsheet. Thank you for looking into this and asking questions!

Please Login or Register  to view this content.

Hello ExcelBeginner326,

The macro validates that a the team has a sheet createed and appends any new data to below any existing data on the sheet.

There is no provision for inserting the formulas anywhere else on the sheet nor deleting the formula once a team has been removed.

To help you with this problem, you would need to post your workbook. We need to see how the data is arranged, what formulas you are using, etc. Otherwise, we are just guessing at what you need.

Please provide before and after examples of your data along with any notes you would like to include.

If your workbook contains any sensitive information, please redact that information before you post.

How To Post Your Workbook

1. At the bottom right of the Reply window, Click the button Go Advanced
2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
4. Click the Select Files button at the bottom middle of the dialog.
5. In the new window Find the file you want to upload, select it, and Click Open.
6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
7. Wait until the file has completely uploaded before you exit the File Manager dialog.