Scribd
Upload
68 views5 pages

Excel Data Validation Purchase Guide

This document provides instructions for selecting the weekday when a product was originally purchased for a product purchase information table. It notes to select the weekday of purchase, not first use, and to leave the cell blank if unsure and check with a manager later. It also references data validation lists on another worksheet to select from for the weekday field.

Uploaded by

M.A.N
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
68 views5 pages

Excel Data Validation Purchase Guide

This document provides instructions for selecting the weekday when a product was originally purchased for a product purchase information table. It notes to select the weekday of purchase, not first use, and to leave the cell blank if unsure and check with a manager later. It also references data validation lists on another worksheet to select from for the weekday field.

Uploaded by

M.A.N
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd

Activation Day

Please select the weekday in which the product was originally purchased, no
weekday in which it was first used. If you are not sure, please leave this cell
then check with your manager, and fill in the weekday later.

Product Purchase Information


Name Weekday Month Price data validation - lists
data validation - number

A text box appears when a cell with a data validation


input message or input title is selected.

To view the code, right-click the sheet tab, and choose


View Code

Data Validation Lists are on the Validation Lists


worksheet

Developed by Contextures Inc. [Link]


product was originally purchased, not the
u are not sure, please leave this cell blank,
n the weekday later.

a data validation
ed.

et tab, and choose

dation Lists

Developed by Contextures Inc. [Link]


Sunday January
Monday February
Tuesday March
Wednesday April
Thursday May
Friday June
Saturday July
August
September
October
November
December

06/04/2021 [Link]
Contextures Products
Pivot Power Premium Add-in
UserForms for Data Entry ebook Kit
Contextures Excel Tools Add-in
Data Entry Search Popup
Data Entry Popup
30 Excel Functions in 30 Days eBook Kit

Contextures Sites & News


Contextures Excel Newsletter
Contextures Excel Tips Website
Contextures Excel Blog
Excel Pivot Tables Blog

Other Excel Products


Contextures Recommends
Time-saving tools for pivot table power users
Step by step instructions and videos
Make instant backups, sort sheets, and many more tools
Makes data entry easier when choosing from long list
Select single or multiple items from a listbox, to enter in a single cell
Sample workbook and easy to follow user guide for key Excel functions

Weekly Excel tips, tutorials, videos, and news


Hundreds of tutorials, tips and sample files
Read the Excel tutorials and share your comments
Pivot table tutorials and tips, with comments and questions

Other Excel tools and training, recommended by Debra

You might also like