I have no idea where to start so any help is appreciated!
So far, I managed to figure out one thing which is to run the code if a cell in column Y is clicked. That's about 1% of what I need it to do...
What I need it to do is:
- Run the code if cell in column Y is clicked
- Register the selected row and look at column Q (e.g. if I click on cell Y4, look at Q4, if Y6 is clicked, look at Q6, etc.)
(I'll use row 4 going forward but it needs to be fluid as to whichever row is clicked)
- If e.g. Q4 says "No" stop the macro
- If e.g. Q4 says "Yes", first check if Z4 has a date in it - if "Yes", msg box pops up saying "Are you sure you want to re-export?", if "No", stop macro.
- If "Yes" do the same that would happen if Z4 has no date which is...- Copy what is in columns C, D, E, H, K, L, M, O, P and Q and whack it into a word document
If it's not possible to register which row is clicked, then alternative I'm thinking is cycle through each row with the same condition (i.e. skip all the rows where in column Q it says No) and whack it all in a word doc, each row having it's own page (i.e. row 4 is page 1 in word, row 5 is page 2 in word, etc.)
Thank you!
Bookmarks