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.
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.