A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Too hard to do?



 
 
Thread Tools Display Modes
  #1  
Old April 15th, 2010, 11:11 PM posted to microsoft.public.excel.charting
LSSTOC Black Belt
external usenet poster
 
Posts: 2
Default Too hard to do?

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?

--
AFS BB
  #2  
Old April 16th, 2010, 11:27 PM posted to microsoft.public.excel.charting
LSSTOC BB
external usenet poster
 
Posts: 1
Default Too hard to do?

Maybe?

"LSSTOC Black Belt" wrote:

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?

--
AFS BB

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:38 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.