Forum Message

Topic: Excel 2010 programming - can anyone help on here?
Posted by: George Turner
Date/Time: 04/10/14 14:43:00

Thanks for the replies - here goes then -

In Excel I want to automate the filling in of a form which contains a number of cells. The information that needs to be put in depends on an initial calculation, and then depending on the result of that calculation a trail follows to complete that form.

In the calculations tab (tab 1) I have done my sums and the result is converted into a text string through conditional formatting. In this cell there are 5 potential answers (of which for the purpose of this explanation) is “Category 1”.

Then I need to go to another tab (tab 2) where there are 5 columns headed with one of the potential answers from the first tab, thus “Category 1”, “Category 2”, “Category 3”, “Category 4” and “Category 5”.

Each of those columns has underneath rows with a number of entries which are labelled, for the sake of argument “Entry 1”, “Entry 2” etc. until “Entry25”  The table below is part of that tab in excel.

Entry #    Category 1  Category 2  Category 3
Entry 1    A100            A107          B345
Entry 2    C567            B210          A103

Then I need to go to a third tab (tab 3) and use a look-up table, for example as shown in the column Phrase (meanings are merely dummy examples):

Code     Phrase
A100     Keep out of the rain
A103     Keep out of the sun
A107     Delicious when eaten raw
B210     Very refreshing
B345     To enjoy anywhere
C567     Lots of fun

Ultimately I want to fill in my form (in tab 4) with the results, which would look like

Category 1    Phrase
Entry 1         Keep out of the rain
Entry 2         Lots of fun

So, from this end result with the form filled in, you can see that when there are many entries under each of the categories and many different codes and phrases, automation is very useful instead of following the trail, with a lot of copy/paste and thus possible errors.

If the answer from calculations was “Category 2” then the form would look like -
Category 2      Phrase
Entry 1            Delicious when eaten raw
Entry 2            Very refreshing

Any help gratefully received!


Entire Thread
TopicDate PostedPosted By
Excel 2010 programming - can anyone help on here?04/10/14 09:06:00 George Turner
   Re:Excel 2010 programming - can anyone help on here?04/10/14 10:09:00 Richard Jennings
      Re:Re:Excel 2010 programming - can anyone help on here?04/10/14 11:12:00 Andy Brown
         Re:Re:Re:Excel 2010 programming - can anyone help on here?04/10/14 12:31:00 Will Watson
            Excel 2010 programming - can anyone help on here?04/10/14 14:43:00 George Turner
               Re:Excel 2010 programming - can anyone help on here?04/10/14 14:57:00 Will Watson
                  Re:Re:Excel 2010 programming - can anyone help on here?04/10/14 17:51:00 George Turner
                     Re:Re:Re:Excel 2010 programming - can anyone help on here?04/10/14 18:10:00 Will Watson
                  Re:Re:Excel 2010 programming - can anyone help on here?04/10/14 18:16:00 Richard Jennings
                     Re:Re:Re:Excel 2010 programming - can anyone help on here?04/10/14 18:29:00 Richard Jennings

Forum Home