Autofill a Column based on Value

Hello Everybody,

Does anybody know how to create a macro that will autofill a column based on information in another Column. I would need for the macro to Check Column I first and see if it has any value. If it does it will then move onto Column N. If column N has no value then Column O will equal Manual. If Column N = Yes then Column O will equal Import. If Column I has no values then the macro will stop running. Thanks for your help.

Please Login or Register  to view this content.

two comments/questions:
1) why you have not posted an attachment (to test code) - the above one uis not testet, but hope it works
2) why use macro, and not filtering?

Just use a formula:
=IF(I1<>"",IF(N1="",O1="Manual",IF(N1="Yes",O1="Import","")),"")
if you really need it as a macro:

Please Login or Register  to view this content.

PS. How about column N not empty, but also not "Yes"?

Its close. Is there a way to make it so that after the macro runs and the value in Column N changes so can the value in Column O. I attached the spreadsheet this time and included the coding I already have. I have a Dropdown menu in Column O that allows it to be changed to Yes. And the reason why I'm creating a macro is because I'm making it for a user not myself so I'm trying to make it as simple as possible and all they have to do is click a button.

Test123.xlsmSorry forgot to put this in the last post.