Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Performing operation on celles between cells with heading

  Asked By: Almas    Date: Oct 02    Category: MS Office    Views: 856
  

I have an excel sheet which looks like this
A b
1 Projects Cost
2 Project1 $40
3 Project2 $50
4 Project3 $30
5 Total Projects $100
I want to to take every cell in Column A that is between the titles
Projects and Total Projects an perform an add $10 for each cell in
column B.
The titles never change but the position of item in rows
change evry
month , because I might have anoth row called project$, that why i can not ust the row number.
Any help is appreciated, i just do not know the exact code in vb

Share: 

 

3 Answers Found

 
Answer #1    Answered By: Leonard Pierce     Answered On: Oct 02

I'm sorry but I don't see why the row  is important. Assuming you are
sorting your data ... Would a formula do the job or do you really want
to use VBA?
The formula could do an INSTR or FIND for Project and then add  $10 to
the value of Col B if found to another column.
You could even reference another cell  for the 10$ in vase that chnged.

 
Answer #2    Answered By: Elisabeth Bell     Answered On: Oct 02

If it's only a once a month operation, a manual intervention might be
easiest. Using a cut/paste-special-operation-add combination would do this
quickly and efficiently. Excel help  has a good explanation of this.

 
Answer #3    Answered By: Midissia Lopez     Answered On: Oct 02

My only concern using the
formulas is that I have another category which has the same projects
name , so I want only the projects  that are between the titles i
mentionned:
A b
1 Opeartion Projects Cost
2 Project1 $40
3 Project2 $50
4 Project3 $30
5 Total operation  Projects $100

6 Capital Projects
2 Project1 $40
3 Project2 $50
4 Project3 $30
5 Total Capital Projects $100


So Like I said i only want to perform  an operation on the projects
that are between the titles Operation Projects and Total Operation
Projects and not the ones that are between Capital
I can not change  the title of thes projects.

 
Didn't find what you were looking for? Find more on Performing operation on celles between cells with heading Or get search suggestion and latest updates.




Tagged: