L
LSSTOC Black Belt
Good Day, I have to take (certain) data from one sheet to another if a
particular cell is not blank dynamically.
F400 PROJ 8029 3/18/10 7.25 12
F400 ACT 8029 3/19/10 KF10-0005 EVANS 9 13
F200 PROJ 8726 3/24/10 7.25 10
F200 ACT 8726 3/25/10 KF10-0006 JOCHEN 13 19
D400 PROJ 62 3/12/10 7.25 12
D400 ACT 62 3/11/10 K10-0039 PALAS 14 20
D200 PROJ 4327 3/30/10 7.25 10
D200 ACT 4327 3/29/10 K10-0040 PALAS
This is what my rows look like.
First row is projected data (filled out ahead of the project starting)
Second row is actual data (filled out as the project progresses)
I need to pull from this sheet only the actual data, only if the last cell
in that column (the project completion date) is not blank and put it in the
next open row on another sheet, and it needs to happen automatically.
Additional intel: The "projected" row WILL be blank in that reference column
for any "IF" statement . My company does not allow macros for security
reasons. I am a novice at best with VB.
Daily task is to input this data in the first sheet one. once a month the
data is collected, charted and printed for a report.
The people doing the printing and data entry don't know excel, and don't
have the time (motivation) to learn it or spend the time needed to do this
manually.
Last 2 columns won't have data until the project completes. Once it
completes, dates and text are entered into cells. These dates and text along
with other row information (But not all) from the "actual" row is moved to
another sheet and accumulated for a dynamic chart. ( I can't get the dynamic
chart to work with blank cells, so I have to have this other sheet, I think?)
this chart displays the data entered in the "actual" rows.
The problem I run into is Blank cells and no macros.
Any ideas?
particular cell is not blank dynamically.
F400 PROJ 8029 3/18/10 7.25 12
F400 ACT 8029 3/19/10 KF10-0005 EVANS 9 13
F200 PROJ 8726 3/24/10 7.25 10
F200 ACT 8726 3/25/10 KF10-0006 JOCHEN 13 19
D400 PROJ 62 3/12/10 7.25 12
D400 ACT 62 3/11/10 K10-0039 PALAS 14 20
D200 PROJ 4327 3/30/10 7.25 10
D200 ACT 4327 3/29/10 K10-0040 PALAS
This is what my rows look like.
First row is projected data (filled out ahead of the project starting)
Second row is actual data (filled out as the project progresses)
I need to pull from this sheet only the actual data, only if the last cell
in that column (the project completion date) is not blank and put it in the
next open row on another sheet, and it needs to happen automatically.
Additional intel: The "projected" row WILL be blank in that reference column
for any "IF" statement . My company does not allow macros for security
reasons. I am a novice at best with VB.
Daily task is to input this data in the first sheet one. once a month the
data is collected, charted and printed for a report.
The people doing the printing and data entry don't know excel, and don't
have the time (motivation) to learn it or spend the time needed to do this
manually.
Last 2 columns won't have data until the project completes. Once it
completes, dates and text are entered into cells. These dates and text along
with other row information (But not all) from the "actual" row is moved to
another sheet and accumulated for a dynamic chart. ( I can't get the dynamic
chart to work with blank cells, so I have to have this other sheet, I think?)
this chart displays the data entered in the "actual" rows.
The problem I run into is Blank cells and no macros.
Any ideas?