Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have 21 columns with headings A, B, C, etc. with values between 0 to
11 in each cell. On a second worksheet, I have a table with interpretations for High, Medium and Low for each of the column headings (A, B, C, etc.) High Medium Low A A-Hi A-Med A-Low B B-Hi B-Med B-Low C C-Hi C-Med C-Low etc. I need to replace the values in worksheet one according to their interpretations e.g. scores between 0 and 3 in the column A should pull the text for A-Low, scores between 4 and 7 should pull the text for A-Medium and scores between 8 and 11 should pull the text for A- High. Similarly for the other columns. Can anyone tell me the best way to do this? I am an absolute newbie with no experience of writing macros or VBA. Thanks, Divyanshu |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Populating Cells from One Worksheet to Another... | Excel Worksheet Functions | |||
Populating form with data from worksheet | Excel Programming | |||
Populating data to other worksheet via data validation | Excel Programming | |||
populating excel cells with data from data sources | Excel Programming | |||
Populating worksheet with data from Access | Excel Programming |