About Us

LSSTOC BB

Thank you for taking a look at this for me.

"Don Guillett" wrote:

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

"LSSTOC Black Belt" wrote in
message ...
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?

--
AFS BB

.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PLS, I need help, it is hard	Attie	Excel Worksheet Functions	6	August 11th 07 10:27 AM
Hard CR in a Cell	Brian	Excel Discussion (Misc queries)	2	December 7th 06 12:52 AM
Hard One.	Chris S.	Excel Discussion (Misc queries)	1	August 23rd 05 10:32 PM
This is a hard one...	goodfella	Excel Discussion (Misc queries)	4	June 17th 05 06:31 PM
re Macro - too hard for me !!	Anthony	Excel Discussion (Misc queries)	3	February 28th 05 05:11 AM

Menu

About Us