mercredi 1 avril 2015

VBA - solving the automation of the addition of new markets

I am trying to automate the addition of new markets to the spreadsheet using VBA.


In Cell E6:J6 I have 6 countries. In E7:J7 I have their respective currency. I want the user to do the following:



  1. Enter a new market into H3 and its currency into I3

  2. Run the macro and the new market and currency appears in K6 and K7


This part I can work out - however, when the user enters an additional market in H3 and I3, if there is a string in K6 and K7 then it will populate L6 and L7 with the new information and so on.


Any ideas?


Thanks


K


Aucun commentaire:

Enregistrer un commentaire