Hi!

I'm new to macros and having some difficulty writing it for this and would love some guidance. I'm trying to copy the values of the range B2:B31 (ignoring blank cells) from Sheet1 into B4:B31 on Sheet2. However, I have four non-adjacent columns on Sheet1 (B2, D2, F2, H2) with the same ranges (B2:B31, D2:D31, etc.) that i'd like to paste adjacently (B4:B33, C4:C33, D4:D33, E4:E33) on Sheet2 - all while ignoring blank cells.


Generally, I would just use =Sheet1!B2 but blanks show up as #N/A and if i write an if that makes it show up as an empty text string "", the formula i'm trying to use after calculates it incorrectly. So I wanted to write a macro that would just output nothing if there's no value in that cell.

Thank you<3

-Lauren