Solved

Excel Macro - Promt to replace partial content of cell

Posted on 2016-08-09
7
39 Views
Last Modified: 2016-08-09
Hi,

I have a small file that summarizes the MS Office 365 Updates compliancy.  
Each month, I have to update manually the formula contains in cell  C3 , C4 , F3, F4
to put the update version followed during the new month.

Is there a way that a macro could prompt me a displaybox telling me the version contain in cell C3 and allows me
to modify the version and then update the forluma in cell C3, C4, F3, F4 with the new value in the summary (if no need to change version value, then the macro simply stop)?


To help, I have attached a simple file of my summary

Thanks alot,
/MLD
Book1.xlsm
0
Comment
Question by:mldaigle1
  • 4
  • 3
7 Comments
 
LVL 48

Expert Comment

by:Rgonzo1971
Comment Utility
Hi,

Why not change the formula to
=COUNTIFS(Table!B:B,"Yes", Table!D:D,A3&"*", Table!D:D,"<>#N/A",  Table!C:C,"<>*Windows Embedded 8.1*")

Open in new window

Regards
EE20160908.xlsx
0
 

Author Comment

by:mldaigle1
Comment Utility
this is a good suggestion, but that cell with change for "Compliant" and "Not Compliant"

Can't use it...

:(
0
 
LVL 48

Expert Comment

by:Rgonzo1971
Comment Utility
Which cell
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 

Author Comment

by:mldaigle1
Comment Utility
Cells A3 & A4 will be replace as "Compliant" and "Not Compliant"
0
 
LVL 48

Accepted Solution

by:
Rgonzo1971 earned 500 total points
Comment Utility
0
 

Author Comment

by:mldaigle1
Comment Utility
This is very acceptable, very very very acceptable!!

:)

Too simple.... was thinking too much Macro!!

Rgonzo1971, you're amazing!!
Smack!
0
 

Author Closing Comment

by:mldaigle1
Comment Utility
Thanks for your eyes!!
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now