Solved

Remove column, auto-width, rename, freeze header rows

Posted on 2011-03-13
5
380 Views
Last Modified: 2012-05-11
I know this is alot for one question but a single answer to any or all of them will result in a new question.  It will not drag on.  

The macro needs to be adjusted so that the following take place automatically.  Column A needs to be removed with the title "Account Trade History" at the top to remain in-tact.  The width should automatically adjust to contents.  The Exp header title should be renamed to Instrament, and the top two header rows should be frozen.  

Assistance is greatly appreciated.
TradeHist-2.3c.xlsm
0
Comment
Question by:rtod2
  • 3
  • 2
5 Comments
 
LVL 10

Expert Comment

by:Makrini
ID: 35124394
TradeHist-2.3c-1-.xlsm

Should be right
0
 

Author Comment

by:rtod2
ID: 35124409
Almost.  Should be Instrument instead of Instrament.  I had misspelled it.  Also the first empty column should be removed entirely.  There should only be one module where we now have two.
0
 
LVL 10

Accepted Solution

by:
Makrini earned 500 total points
ID: 35124469
TradeHist-2.3d.xlsm

How about now?
0
 

Author Closing Comment

by:rtod2
ID: 35124491
Perfect!!

Follow-up question on the way...
0
 

Author Comment

by:rtod2
ID: 35124505
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
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…

816 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now