I'm having a rough time creating a macro to do what I need. I know I'm going to need a couple of them to achieve the effect ultimately, but I'm going to start with it in a smaller scale. I have a table that is say about 50 lines. It has 7 columns. I'm looking for it to update a word document but only if column b has 'yes'. Then it would ultimately assign itself to a table based on column d ranked by column c. I know it's possible, I just need help figuring out the right macros. If I can figure out assigning the items to say table 1, then I can replicate it and replace the information with the other options. Any help on this is highly appreciated. For now, for the sake of the macros, the file is called test.docx while the excel file is called test.xlsm and both are located at C:\. Any thoughts?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Excel VBA
- Thread starter asirainis
- Start date
