Click My View Smart Forms will help every-day business users of Excel to work faster, more efficiently and enhance spreadsheet capabilities, with little or no effort.

 

All Click My View tools are specially designed to help business users of Excel improve productivity.

 

People who need to complete their work in minimum time, with minimum effort, ideally with just a click or have it automated, plus little or no time to set it up - without any technical skills.

 

The aim of the tools is to save time, reduce workload and improve the quality of work. This is through tools that are easier to use, work faster and simpler than what is in use, and to introduce more effective methods than those in typical use - such as Dependency Lists.

 

Most Smart Forms automatically replace standard Excel features, with no setup required, as they have default settings for the most common needs. Activating options typically only takes moments, such as assigning a range name to a drop-down list. 

 

 

  • Smart List – replaces Excel drop downs, searchable, multi column display, many options
     

  • Smart Dependency List – a new approach, much faster and easier than traditional methods
     

  • Smart Text Edit – a window for cell text editing - with basic formatting, real tabs, bullets, etc.
     

  • Smart Cell Calendar – no more blindly typing dates – fast selection of the day, month & year
     

  • Smart Menu -  intelligent menu - click to open workbooks, unhide sheets & cells, run macros
     

  • Smart Sheets – click to go to any sheet, plus click for fast hiding / unhiding of sheets


 

The video below provides a quick overview of the Smart Forms

Also Save Time & Effort With Smart Functions

A common step that many users perform on a regular basis is 

Copy and Paste a Column of Totals into another column and Save As Values

This single formula can save you a minute or two every single time!

=CMV_Paste_Cell_Value(ValueRange, FormulaRange)

This and other Smart Functions enable manual steps to be easily automated - just use a check box or radio button to trigger the functions!

Check out the Video describing the End Of Month process to see how entire processes can be automated

Click My View Smart Functions complement Smart Forms - they can:

  • Replace manual tasks

  • Enable genuine interaction with users, with message boxes for alerts and actions

  • Find duplicates in multiple ranges, with a single formula

  • Copy and Paste values into a range of cells And Clear a range of cells

  • Permanently time stamp new rows or changed rows, with current date and time 

  • Copy and Paste a range of formulas, retaining cell references - copy down, across

  • Copy and Paste ranges of formulas as values - preserve totals, sequence numbers

  • Transpose Formulas, retaining correct cell references

  • Automate the export of CSV data and Read and Write text files

  • Plus a host of other functions to help you save time, improve quality, work smarter
     

Save Effort, Ease Your Workload, Add New Capabilities To Your  Spreadsheets

With 50+ productivity functions that can help you save time, work smarter, work easier.

We also have an Excel application that saves frequently used views, and automatically filters 

columns and rows to show you the view of the data you need. (unwanted rows and columns are instantly hidden)

Customer Satisfaction Is Important To Us
We believe in the effectiveness and quality of our products and are confident they will save you time and ease your workload.
 
If for any reason you are not satisfied within 30 days, we will happily return your money.
Guaranteed!
 
 
 
 
 
 
 
 
 

Smart Functions Will Save You Time, Ease Your Workload

And Add New Capabilities To Your  Spreadsheets

Automate Manual Tasks With Simple Formulas - Save Time & Effort

Find Duplicates - Highlight e.g. =CMV_FindDuplicateCells(A1:A30)

Copy/Paste Formulas  - As Values e.g. =CMV_Paste_Cell_Value (A1:Z30, A1:Z30)

Clear A Cell Range  - To Empty e.g. =CMV_ClearRange(A1:Z30)

Export Data As Excel CSV File e.g. =CMV_ExportCSVFile("ExportFile.CSV",A1:Z30)

Read/Write File - Text and CSV  e.g. =CMV_FileReadString("ControlFile.txt")

Instant Backup With A Click e.g. MyWorkbook Backup 20180607 103025.xlsx

Smart functions are specially designed to help every-day Excel to write simple formulas that genuinely save time and effort.

Save Time - Automate Manual Work

See This Automated End Of Month Process

"Saves me time every day!"

A detailed walkthrough video can be viewed later in this page

Speed Up Data Entry, Validation, Analysis

 

Highlight Duplicates As You Type e.g. =CMV_FindDuplicateCells(C1:C200,MyColor)

Default Data Automation e.g. =CMV_Paste_Value(A10:A12,IF(A1=1,"ABC","XYZ"))

Alert User - Change Color of Row, Range, Cell e.g. =CMV_ChangeCellColorToYellow(A1:Z1)

Stop User - With OK Message Box e.g. =CMV_MsgBoxOK("Be aware that ...........")

Stop User - With Answer Message Box e.g. =CMV_MsgBoxYesNo("Please confirm that ..........")

One Single Formula Checks For Duplicates As You Type

Accelerate Spreadsheet Development And Testing

Display Formula Chains - Quickly Find And Fix Problems e.g. =CMV_GetFormula(A1)

Transpose Formulas - Keeping Cell References e.g. =CMV_TransposeToRows(A1,A1:Z1)

Fast Concatenation Of Ranges + options  e.g. =CMV_ConcatRange(A1:Z1,”; “)

Clear A Range Of Cells - To Empty e.g. =CMV_ClearRange(A1:Z30)

Set Cells True, False or Null  e.g. =CMV_True(A1)&CMV_False(A2)&CMV_Null(A3)

Copy Paste New Formula On The Fly  e.g. =CMV_Paste_Cell_Formula (A2:Z2, A1:Z1)

Dynamic Fill Down e.g. =CMV_Paste_Formula(A1:OFFSET(A1,CMV_GetLastRow()-1,0), A1)

Dynamic Formula Selection e.g. =CMV_Paste_Formula(CHOOSE(A1,C1,C2,C3,C4)

Create Formulas On The Fly e.g. =CMV_Paste_Formula(A1,If(B1=1,"=C1*10","=C2*12"))

Instant Workbook Backup - Versions e.g. MyWorkbook Backup 20180607 103025.xlsx

Save Time Finding & Fixing Errors In Formula

"Saves me time every day!"

Add New Power and Capabilities To Spreadsheets

In additon to all of the above functions there are also new capabilties:

Advanced SEARCH - Match any of MUTLIPLE CRITERIA, in both TEXT and CSV strings,

for exact match, partial match, word match and phrase match (text between CSV commas):

e.g. 2=CMV_Search_Word_CSV("Apple,Pear","peach,apple,pear,strawberry,Pear")

e.g. 5=CMV_Search_Exact_CSV("Apple,Pear","peach,apple,pear,strawberry,Pear")

Get WORD n in TEXT string e.g. "four" =CMV_GetWordString("This is word four",4)

Get PHRASE n in CSV string  e.g. "a pear" =CMV_GetWordCSV("peach,apple,a pear",3)

Get DATE FORMAT for region or user preference e.g. =CMV_GetDateFormat()

Read file record - control data, lookup data e.g.=CMV_FileReadString("LookupTable.txt",3)

Write file record - statistical data or event e.g.=CMV_FileWriteString("LogFile.txt")

Make file name with path to workbook directory e.g.=CMV_MakeFileName(A1)

Does File or Directory Exist e.g.=CMV_FileOrDirExists("More Data.txt")

Is a Workbook Open  e.g.=CMV_IsWorkBookOpen("Another Workbook.xlsx")

Is Sheet present e.g.=CMV_IsWorksheetPresent("Sheet1")

Plus, a host of other functions from getting and setting cell colors, to WAIT and F9 Calculate

Click Here To See Working Examples 

SaveTime.jpeg

Click Here For Examples Worbook

.xlsx workbook of the above

Click Here For Functions Directory

details of options & arguments

Future Functions 

 

Smart Functions are specially designed to help every-day Excel users to save time,

by using simple formulas that really do save time and effort in Excel.

Our development plans include extensions to some of the existing functions, new and complimentary functions for the existing packs, plus some new packs.
All are aimed at saving you time in your day-to-day work.

Please join our mailing list for news and updates 

We welcome your feedback on how to improve our functions.

We also welcome feedback on what else would help you to save time working with Excel.

Just drop us note using the contact form below.

Inclusions When You Purchase A Functions Pack

An Excel Add-In pack includes all the functions for that pack, plus the Common Functions, as defined in the Functions Directory at time of purchase.

1 Computer Licence Per Pack (unless specifically stated otherwise)

Functions Directory, detailing functions, arguments and options

A pdf file of the examples workbook for easy reference

The examples workbook for the functions pack

Access to all demonstration workbooks

Access to All How To Videos

30 Day Money Back Satisfaction Guarantee 

The licence is valid for all users of that computer, does not have an expiry date and whilst tied to the computer it is first installed on, it can be moved a number of times.

System Requirements

All forms and functions are Excel Add-In Files (xlam)

Functions are specially designed for inclusion in user formulas

Forms and Functions are external to your workbooks

Works with XLSX, XLSM and XLSB workbook formats

For Excel 2010, 2013, 2016, Office 365 - 32 / 64 bit

Windows 32 / 64 bit - Macros must be enabled

Sorry, but please do not purchase if you have a Mac

We are aware of some critical differences with Mac Excel that we must address.

We are planning on doing so in the near future and will keep you advised.

Please join our mailing list for news and updates

Smart Functions are specially designed, built & tested to be called from formulas.

 Most work just fine when called from vba but we cannot guarantee that they all do.

Learn How to Replace Manual Steps With Formulas

 

(End Of Month Process Detailed Walkthrough)

Learn how formulas 

  • Start & Control The Process

  • Ask For User Confirmation

  • Find & Highlight Duplicates 

  • Copy Formula Values Into Relevant Month Column

Learn how formulas 

  • Create A Unique File Name

  • Export Summary Data As CSV

  • Read a Row From CSV File

  • Increment Month Number

  • Reset For Next Month

Have You Seen The Click My View Application?

Intelligent Filtering Of Rows AND Columns

Data Entry Pop-Ups - List Validation

Filtering, Menu, Date Calendar,

Cell Text Editing With

Real Formatting 

Hide and Unhide Rows and Columns Instantly

Especially designed for Everyday Excel Users.

Users who want to work faster, easier, smarter,

without technicalities, macros or programming.

  • YouTube Social  Icon
  • Facebook Social Icon
  • Twitter Social Icon
Sunshine Solutions Pty Ltd (ABN 30 124 423 552)
34 Balemo St, Minyama, Queensland Australia 4575
Email info@sunshinesolutions.com.au
  • YouTube Social  Icon
  • Facebook Social Icon
  • Twitter Social Icon