rtod2
asked on
Expand macro to include Leg#s
I need to add Leg#s before each spread.
Leg1 would always appear next to the name of the Spread where Leg2 is the next row of the same spread. The same would go for Leg3 and Leg4 should there be a situation where they exist. The Leg numbers should start over as soon as a new Spread is introduced.
Column headers should also be bold also as well as the title Account Trade History.
trade-2.1g.xlsm
Leg1 would always appear next to the name of the Spread where Leg2 is the next row of the same spread. The same would go for Leg3 and Leg4 should there be a situation where they exist. The Leg numbers should start over as soon as a new Spread is introduced.
Column headers should also be bold also as well as the title Account Trade History.
trade-2.1g.xlsm
ASKER
Not really. Each trade shown has either one or two legs. That was badly defined by me. I made that more complicated than it should be. There are only one or two-legged trades. Nothing else exists.
I also wanted the title and headers bolded though.
I also wanted the title and headers bolded though.
ASKER
Note that there is no change in the dating sequence yet.
Can you type in an example of some of the "leg" results you want and I'll see if I can understand what you are after
ASKER
At some point I would like to talk through this with someone but that communication isn't allowed here. Suggestions are greatly appreciated. My developer suggested I get it to this point first.
ASKER
The first several rows here have a leg# added http://screencast.com/t/WF0hnvqi8pon
ASKER
They are nothing but individual rows or paired rows really. One right after another. 1,1,1,12,12,12,1,1 etc.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect. See redirect
ASKER
Here is the new question >> https://www.experts-exchange.com/questions/26882733/Include-Unit-Numbers-for-Single-and-Paired-Rows.html
Copy-of-trade-2.1f-1.xlsm