?
Solved

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

Posted on 2011-03-13
5
Medium Priority
?
393 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 2000 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

Featured Post

Hire Technology Freelancers with Gigs

Work with 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 get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Manually copying shapes and their assigned macros one by one to a new location can be tedious, but if you use the Excel utility workbook attached to this article, the process will be much quicker and easier.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
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…

589 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