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
rtod2Asked:
Who is Participating?
 
MakriniConnect With a Mentor Commented:
Copy-of-trade-2.1f-1.xlsm

I think I see what you mean.  Is this any better?
0
 
MakriniCommented:
Does this do it?

 Copy-of-trade-2.1f-1.xlsm
0
 
rtod2Author Commented:
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.  
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
rtod2Author Commented:
Note that there is no change in the dating sequence yet.
0
 
MakriniCommented:
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
0
 
rtod2Author Commented:
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.
0
 
rtod2Author Commented:
The first several rows here have a leg# added http://screencast.com/t/WF0hnvqi8pon
0
 
rtod2Author Commented:
They are nothing but individual rows or paired rows really.  One right after another.   1,1,1,12,12,12,1,1 etc.
0
 
rtod2Author Commented:
Perfect.  See redirect
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.