Validation Update

[longytravel]

morning,

I have got a list on a summary sheet - i have defined the name and use it as a source for the a validation list

Each item in the list has a score out of 10 so: Football (8)

I can add and remove items using the dynamic features of define but i have made a mistake on one the scores and have nowcorrected it too: Football (7)

How can i change all the Football (8)'s in the worksheet to relfect the new score entry of Football (7) without going through the whole workbook?

Its a shame when i change it on the summary sheet it doesnt filter through?

Any help greatfully recieved

Cheers

 

[baitmaster]

Select all worksheets at the same time

Select all cells on the active worksheet

Ctrl + H to find and replace all instances of "Football (8)" with "Football (7)"

This approach will do the work on all cells of all sheets, at the same time

 

[longytravel]

Simple but effective!

Thanks!

Have you got any views on the below - this is my next problem!!

Morning,

Wondering if someone can help

I would like to create list of roles (Team Manager, Senior Manager etc) for a business - there a number of the these roles throughout a large business

I have split the business areas up onto different tabs (so we might have a senior manager in HR (tab 1) and a senior manager in customer contact (tab 2)

Each role has a set of skills - 13 headings (R : AD) and then within the headings i have a drop down menu for the level they are at (e.g Business Acuman 'Advanced', Planning 'Expert')

I guess i would like a master sheet that holds all the role titles and their skills and you can amend the skills lists as you wish

If senior manager is on the master sheet with the skills it will automatically populate the other tabs where senior manager is listed

If you change the skill levels on the master sheet it changes all the roles on the correspionding sheets (so if i decide senior manager is actually Expert for Business Acumen i change it on the master sheet and it changes all the references in the workbook)

Hope that makes sense - look forward to suggestions/code etc!

THanks as ever!
<!-- / message -->