Macro to paste cells from one sheet into another

[ayvee0]

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

[AlphaFrog]

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.

You could modify your "after" formula to ignore the "". What is that formula?

Otherwise...

Please Login or Register  to view this content.

[ragulduy]

you could try and use something like:

Please Login or Register  to view this content.

[ayvee0]

Thanks a lot for the help!!!

For the future, how do you modify the formula to ignore the ""? the ISBLANK function returns FALSE

[AlphaFrog]

Thanks a lot for the help!!!

For the future, how do you modify the formula to ignore the ""? the ISBLANK function returns FALSE

You're welcome.

It depends on the formula.