Excel Data Validation
Solved/Closed
Hello,
I have a master spreadsheet to collate data from spreadsheets filled in by my colleagues.
Column b is 'Transaction Type' and I want to provide a dropdown list on the input sheets based on a named list in my master called Transactions. This list is subject to change and I don't want to have to update on each individual input spreadsheet.
Data Validation doesn't allow me to link to another workbook. Can anyone suggest a way round this?
Many Thanks.
I have a master spreadsheet to collate data from spreadsheets filled in by my colleagues.
Column b is 'Transaction Type' and I want to provide a dropdown list on the input sheets based on a named list in my master called Transactions. This list is subject to change and I don't want to have to update on each individual input spreadsheet.
Data Validation doesn't allow me to link to another workbook. Can anyone suggest a way round this?
Many Thanks.
Related:
- Excel Data Validation
- Display two columns in data validation list but return only one - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Tmobile data check - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Gif in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
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.