I have attached an excel workbook with two sheets namely JER and CBPL. What I am hoping to get your help are:
1) A Macro button which when pressed pops up a box asking "Which Section do you require" and then " Please mention Section Code. (The section - A,B,C,D,E and Section code eg 1.0, 1.01, 1.02 etc are found on the second sheet CBPL)
2) Once we mention the code, the revelant description found in column C of CBPL(Sheet 2) gets automatically copied onto the D25 cell of JER(Sheet 1) and the relevant price in coloumn G of CBPL (Sheet 2) gets copied onto I25 cell of JER (Sheet1).
If we press the macro button again, and enter the section and code, the next description should fit in D26 and price should go into I26.
Is Macro the best way around for this? If so could you please help me with this?