• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 358
  • 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
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
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
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

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