Solved

Excel Macro - Promt to replace partial content of cell

Posted on 2016-08-09
7
42 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 49

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 49

Expert Comment

by:Rgonzo1971
ID: 41749131
Which cell
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

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

Accepted Solution

by:
Rgonzo1971 earned 500 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

832 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