Excel Data Validation
Solved/Closed
Related:
- Excel Data Validation
- Transfer data from one excel worksheet to another automatically - Guide
- Display two columns in data validation list but return only one - Guide
- Tmobile data check - Guide
- Excel free download - Download - Spreadsheets
- Excel marksheet - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Nov 1, 2011 at 10:08 AM
Nov 1, 2011 at 10:08 AM
Hi,
Just pull the data from one workbook to another.
Workbook 1: select empty cell, type: =
Workbook 2: select the cell you wish to see in woorkbook 1 and hit enter.
The value of workbook 2 is now visible in workbook 1.
Now you can create a dropwdown list.
Best regards,
Trowa
Just pull the data from one workbook to another.
Workbook 1: select empty cell, type: =
Workbook 2: select the cell you wish to see in woorkbook 1 and hit enter.
The value of workbook 2 is now visible in workbook 1.
Now you can create a dropwdown list.
Best regards,
Trowa
Nov 3, 2011 at 04:37 AM
I'm up and running now. I didn't realise the source list has to be in the same book.
I appreciate your help.