Any thoughts on how to achieve the following:
IF: "@" contained in column A then calculate running total of values in column B and display results in column C
IF: "<>@" contained in column A then calculate running total of values in column B and display results in column D
----a------b--------c---------d
1 atl
2 @phi-"-300"---"-300"
3 @phi
4 @phi
5 @stl-"-375"---"-675"
6 @stl
7 @stl
8 mon-"106"----------------"-106"
9 mon
10 mon
11 fla--"-300"---------------"194"
12 fla
13 fla
nevermind, got it.
If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks