Geeta2014
New Member
- Joined
- Aug 9, 2014
- Messages
- 16
- Office Version
- 2019
- 2016
- 2010
- Platform
- Windows
Hi All,
i can find my way around vba [I am more of an Excel formula user]. Every now and then I need to use one of these. Right now, I am going through the forum and i most likely will find code pieces of what I need, and then i will combine.
However, perhaps one of you good souls already have a vba code that can accomplish what I need. I have laid it out logically as i can below. After the vba runs [whether I add or I delete], I'd like to automatically transfer the updated data to a Word file [tell me if its possible or impossible].
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
i can find my way around vba [I am more of an Excel formula user]. Every now and then I need to use one of these. Right now, I am going through the forum and i most likely will find code pieces of what I need, and then i will combine.
However, perhaps one of you good souls already have a vba code that can accomplish what I need. I have laid it out logically as i can below. After the vba runs [whether I add or I delete], I'd like to automatically transfer the updated data to a Word file [tell me if its possible or impossible].
=(ROW()-1&"=") | Argentina | =(ROW()-1&"=")Argentina | Need a vba code that will: 1. Search for a specific string (e.g. Barbados) that I type into an input box, Delete the row with Barbados I also want the code to loop through and make sure the the text in Column B is in alphabetical order. (If there is a way to add numbering plus the equal sign within the code so I no longer need Column A, i am open to that also). | |
2= | Aruba | 2=Aruba | ||
3= | Barbados | 3=Barbados | 2. Need code that will loop through Column B, confirm that what I type in an input box is not present in Column B, and once confirmed, code will Add in alphabetical order a new country (e.g. Venezuela). (If there is a way to add numbering plus the equal sign within the code so I no longer need Column A, i am open to that also). | |
4= | Bonaire | 4=Bonaire | ||
5= | Chile | 5=Chile | ||
6= | Curacao | 6=Curacao | ||
7= | St Lucia | 7=St Lucia | ||
8= | Trinidad | 8=Trinidad |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>