Getting prompt-name list while entering data
Solved/Closed
Related:
- Getting prompt-name list while entering data
- Create & name worksheets from a list and copy data ✓ - Forum - Excel
- Growing list of chart data ✓ - Forum - Office Software
- Find data by entering data in another cell ✓ - Forum - Office Software
- How to freeze the =today() function once data has been entered - Forum - Excel
- Excel data validation list multiple columns - Guide
2 replies
TrowaD
May 2, 2011 at 09:32 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
May 2, 2011 at 09:32 AM
Hi Suryam,
Date validation could work for you.
Create a list of the names of your old customers on a different sheets or on the bottom of your sheet or anymwhere.
Select the destination range (B31:B42), goto top menu > validate.
Below Allow choose list and below Source select the range you used for your old customers list.
Hope this helps.
Best regards,
Trowa
Date validation could work for you.
Create a list of the names of your old customers on a different sheets or on the bottom of your sheet or anymwhere.
Select the destination range (B31:B42), goto top menu > validate.
Below Allow choose list and below Source select the range you used for your old customers list.
Hope this helps.
Best regards,
Trowa