create new column macro

Posted on 2011-03-09
Last Modified: 2012-05-11
I need a macro that will make a new output tab with a new column for the trade history section of the original tabs (pm or rm).  Each row is considered a leg.  I need the new column to denote a number for each leg of any spread type and start over with the next symbol.  An example of what this might look like is shown here >>
Question by:rtod2
  • 2
  • 2

Expert Comment

by:Eric Zwiekhorst
ID: 35092348
Dear RTOD2,

I would love to help out but I have absolutely no idea of what you willing to achieve?

Could you explain more in detail perhaps with a  before and after example..



Author Comment

ID: 35092431

I want my time listed (UTC -6) and their time derived automatically, based on where they pull up the page.  I think Google uses network time or something to do that.  Not sure.  Need help.

Accepted Solution

Eric Zwiekhorst earned 500 total points
ID: 35092527
You are still not making your question clear to me..

please example of how it is, example of how it should be and then text on what has been done to come to hte result.
WHith that I can program some code that does the job.
But I have to understand what it is you want...



Author Comment

ID: 35092557
I've been as clear as I know how to be.  Perhaps someone else will understand.

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question