Macro to copy paste values if cell is not empty

Hi everybody,

I need your help today for a quite basic procedure (I think) on VBA. The only problem is that I don't know any VBA so I thought about asking for your kind help for the basic functions that might be useful.

I have 2 spreadsheets A and B.

The thing I want to do is go through a column (called correction in my example) and check if the cell is empty or not on spreadsheet B.

If that cell is empty, then we move to the next cell which is one row below on the same column.

If that cell is not empty, then I would like to memorize the value of all three columns (called WBS, meaning and correction) and put them on the first spreadsheet A in an array.

I would like to do this for all cells within Column Correction.

If somebody could help me with the functions, I know how to do all of them in excel and I do understand the basics of while, if and for loops but I have a hard time finding the good syntax as everything I write ends up bugging ...


Thank you so much!

Xenthys

Thank you so much for your answer.

I do understand what you mean even though it seemed more intuitive for me to do something like:
For i= first row not empty until last row not empty
screen each cell and when it is not empty copy paste the 3 values on the other spreadsheet
otherwise move to the next one.


This because my dataset is full of "holes" and I may very well have only 3 values on that column correction in about 500 rows, separated by dozens of rows ...

That is incredible, I am amazed at how you could do this so quickly when I honestly spent almost half a day doing something that doesn't work. Well, thank you again, I wil go through all your code very thoroughly and ask for help about any function if I haven't understood something.