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

Posted on 2011-03-13
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.
Question by:rtod2
  • 3
  • 2
LVL 10

Expert Comment

ID: 35124394

Should be right

Author Comment

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

Accepted Solution

Makrini earned 500 total points
ID: 35124469

How about now?

Author Closing Comment

ID: 35124491

Follow-up question on the way...

Author Comment

ID: 35124505

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

747 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

10 Experts available now in Live!

Get 1:1 Help Now