Maybe too hard to do?


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 itel: 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?
 
Ad

Advertisements

D

Don Guillett

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.
 
Ad

Advertisements

L

LSSTOC BB

Thank you for taking a look at this for me.

Don Guillett said:
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)


.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top