so i tried asking chatbot this question and im not sure if this is right..... In excel How do I use VBA to copy cells "C3" in sheet 1 to cell "E23" in sheet 2, cell "E3" in sheet 1 to cell "F5" in sheet 2, cell "G3" in sheet 1 to cell "B22" in sheet 2, cell "H3" in sheet 1 to cell "B13"in sheet 2, cell "I3" in sheet 1 to cell "B20" in sheet 2, cell "K3" in sheet 1 to cell "C20" in sheet 2 starting from row 3 from sheet 1 only if cell "E3" in sheet 1 is filled in and if column "K" in sheet 1 is filled in afterwards. this is the code i got (Code, 31 lines)

ChatGPT right ???

Don’t have an account yet? Register yourself now and be a part of our community!

This site uses cookies. By continuing to browse this site, you are agreeing to our use of cookies. More Details Close

Your browser has JavaScript disabled. If you would like to use all features of this site, it is mandatory to enable JavaScript.