excel - Solving the automation of the addition of new markets -
i trying automate addition of new markets spreadsheet using vba.
in cell e6:j6 have 6 countries. in e7:j7 have respective currency. want user following:
- enter new market h3 , currency i3
- run macro , new market , currency appears in k6 , k7
this part can work out - however, when user enters additional market in h3 , i3, if there string in k6 , k7 populate l6 , l7 new information , on.
any ideas?
this hard without seeing data sample, looks arranging data against regular flow of data top left bottom right.
from description seems data looks this:
consider re-arranging data in table first column has country , second column has currency. select cell in new arrangement , click insert ribbon > table. dead easy add new countries. click next empty cell , start typing
Comments
Post a Comment