asked on

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

Rgonzo1971

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

mldaigle1

ASKER

this is a good suggestion, but that cell with change for "Compliant" and "Not Compliant"

Can't use it...

:(

Rgonzo1971

Which cell

mldaigle1

ASKER

Cells A3 & A4 will be replace as "Compliant" and "Not Compliant"

ASKER CERTIFIED SOLUTION

Rgonzo1971

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mldaigle1

ASKER

This is very acceptable, very very very acceptable!!

:)

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

Rgonzo1971, you're amazing!!
Smack!

mldaigle1

ASKER

Thanks for your eyes!!