Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA:Populating Cells/List From External Data
Hi,
can anyone help, I have a background in Perl, JScript etc but am new to Excel/VBA. I need some hints or prefferably code that will allow me to perform the following on an Excel worksheet. I am trying to populate several "cells" from data which is external to the Excel application, the data is in the format: Player#Club#Cost i.e. Ronaldo#Manchester United#8.0 I want the "Player" part of the data to be read into list form when a cell is selected, if one of the players from the list is selected then that player will populate that cell (D1:D11) - ALSO, the "Club" will populate another cell AND the "Cost" another cell, i.e. Cells D1:D11 will be the PALYERS Cells E1:E11 will be the CLUBS Cells F1:F11 will be the COSTS If I could push my luck a little further then I would also like a bit of data checking to be performed at the same time - I can only allow 2 players from the same club to be selected, anymore is not allowed - so if cells E1:E11 contain MORE THAN 2 of the same string value then I need a warning, maybe if the cells containing the cinflicting data could FLASH in a red colour. thanks for any help, Mark... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation list populating multiple cells | Excel Discussion (Misc queries) | |||
Excel Macro for taking data external data and populating it on a sheet and deleting unwanted data | Excel Programming | |||
Populating dropdown list 2 with data depending upon what was selected in list 1 | Excel Programming | |||
Populating data from an external database | Excel Programming | |||
Populating data from an external database | Excel Programming |