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:
- Enter a new market into H3 and its currency into I3
- 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