• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 347
  • Last Modified:

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
0
rtod2
Asked:
rtod2
  • 7
  • 3
1 Solution
 
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
 
rtod2Author Commented:
Note that there is no change in the dating sequence yet.
0
Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

 
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
 
MakriniCommented:
Copy-of-trade-2.1f-1.xlsm

I think I see what you mean.  Is this any better?
0
 
rtod2Author Commented:
Perfect.  See redirect
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 7
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now