• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 53
  • Last Modified:

Excel Macro - Promt to replace partial content of cell

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
mldaigle1
Asked:
mldaigle1
  • 4
  • 3
1 Solution
 
Rgonzo1971Commented:
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
 
mldaigle1Author Commented:
this is a good suggestion, but that cell with change for "Compliant" and "Not Compliant"

Can't use it...

:(
0
 
Rgonzo1971Commented:
Which cell
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
mldaigle1Author Commented:
Cells A3 & A4 will be replace as "Compliant" and "Not Compliant"
0
 
Rgonzo1971Commented:
0
 
mldaigle1Author Commented:
This is very acceptable, very very very acceptable!!

:)

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

Rgonzo1971, you're amazing!!
Smack!
0
 
mldaigle1Author Commented:
Thanks for your eyes!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now