| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel 07 Dynamic copy certain cells if criteria is met onto next s
Maybe it's too hard?
"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 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Cells Based on Criteria in VBA | Excel Programming | |||
| Copy cells from one sheet to another based on criteria | Excel Programming | |||
| what criteria needed to copy non blank cells to another location? | Excel Worksheet Functions | |||
| macro to copy cells that meet criteria (mattour) | Excel Programming | |||
| macro to copy cells that meet criteria (mattour) | Excel Programming | |||
![LSSTOC BB[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
