okeyuzosike
Programmer
Good morning gentlemen,
I am working with VB6. Please, I need your assistance. I have a spreadsheet with 4 columns containing data. The 5th column "E" has no data.
----A----- -B-- -C- ---D--- ---E---
Totalhours|Name|Age|Address|
---------- ---- --- -------|-------
0000000005|Jack| 35|New York
My objective is to check for any column that has no data, then MOVE the content of Column "A"(Totalhours) to the empty column. In this case, the empty column will be "E".
Pseudocode:
Check columns
If column has data, skip that column
Elseif column is empty Then
MOVE the content of Column A to the empty column
Endif.
After the process, the result should be like this:
-B-- -C- ---D--- ---E-----
Name|Age|Address|Totalhours
---------- ---- --- -------
Jack|35 |New York|000000005
Thank you all.
Okey.
I am working with VB6. Please, I need your assistance. I have a spreadsheet with 4 columns containing data. The 5th column "E" has no data.
----A----- -B-- -C- ---D--- ---E---
Totalhours|Name|Age|Address|
---------- ---- --- -------|-------
0000000005|Jack| 35|New York
My objective is to check for any column that has no data, then MOVE the content of Column "A"(Totalhours) to the empty column. In this case, the empty column will be "E".
Pseudocode:
Check columns
If column has data, skip that column
Elseif column is empty Then
MOVE the content of Column A to the empty column
Endif.
After the process, the result should be like this:
-B-- -C- ---D--- ---E-----
Name|Age|Address|Totalhours
---------- ---- --- -------
Jack|35 |New York|000000005
Thank you all.
Okey.