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! |
Topic | Date Posted | Posted 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 |