some vba coding from pseudo code

[vofzxy]

good day all, i have a "simple" issue, it's just i do not know how vba works,
i have done basic C /matlab but thats about it

ok here goes i have 2 problems i HOPE to solve

situation: 2 cols of data (54k long ><" ) col A & B
aim: copy data from col B to col A, only if the cell in col A is blank

PSEUDO CODE:

//I KNOW LOL, THANKS FOR STARTING AT 1 NOT 0
VAR X =1

// check cell AX is empty, else copy from cell BX
if sheet.cell.A(X) == isblank();
sheet.cell.A(X) = sheet.cell.B(X)

//check for last row
if sheet.cell.A(X) == isblank() & sheet.cell.B(X) == isblank();
exit

// increase X
X++

//loop?


2nd situation: i have data is MM/DD/YYYY, I want to convert them to YYYYMMDD

i really do not have any idea on this, i am thinking in terms of reading each digit putting them in some LONG CHAR
or individual "BOXES" and reading them backwards

is it possible?

cheers

thanks so much.

 

[vofzxy]

CHEERS.

thanks for all the help guys.