Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Excel Macro - Promt to replace partial content of cell

Posted on 2016-08-09
7
Medium Priority
?
48 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 53

Expert Comment

by:Rgonzo1971
ID: 41748948
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
ID: 41748974
this is a good suggestion, but that cell with change for "Compliant" and "Not Compliant"

Can't use it...

:(
0
 
LVL 53

Expert Comment

by:Rgonzo1971
ID: 41749131
Which cell
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Author Comment

by:mldaigle1
ID: 41749140
Cells A3 & A4 will be replace as "Compliant" and "Not Compliant"
0
 
LVL 53

Accepted Solution

by:
Rgonzo1971 earned 2000 total points
ID: 41749187
0
 

Author Comment

by:mldaigle1
ID: 41749263
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
ID: 41749265
Thanks for your eyes!!
0

Featured Post

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

610 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