I extracted a file & converted it to xl format. Every 4 rows there is a BLANK row dividing the next section/rows of data. I tried using Data Sort & Advanced...

How do I open a spreadsheet with macros disabled already? Reason: I am exporting data from Access to a pre-formated spreadsheet (which I cannot change). Every...

How to change the default printing parameters on Excel & keep them changed for future workbooks. Example: Normally I use Printing margins 0.25 on all...

I have a neat VB code that I use in Excel. This code imports data from a text file into columns in an excel spreadsheet. The excel file has two worksheets,...

I want to start at column 20 and incrment by 1 and insert a heading for each column - all via a macro. I can capture the column index but I can't seem...

I was able to do this cell by cell with the following method: 1. Click the cell containing the Conditional Sum formula you wish tp edit. you conditional...

I have a 10 sheet workbook that I will be sending out to various users around the world. For their convenience, we are adding a lot of drop down lists...

Hi I have 1200 lines of text and numbers in the form below Gross Sales 1200 1500 2400 1100 Garden 40 50 65 ...

Thank you both for your assistance. I found that the ???,??0 format worked best for what I needed to accomplish. I really appreciate your taking the time to...

In Office XP - Excel - I want to copy a column from one sheet to another sheet in the same workbook. I want the copied links to recognize row deletions and...

I've got an excel spreadsheet that tracks attendance (time in/out). We work 8 or 10 hour days depending on the shift. We are required to be as close to 0 hrs...

Using 2003 Sheet1: Current macro calculates a range of cells from a fixed upper-left range cells F5 to G200.: (Note that Sheet1 is a Pivot-table already...

I posted this before and, since I am completely mystified, I am posting again: "I have three worksheets of identical layout (and in the same workbook), the...

Hi, I currently run many complicated Macros in Excel 2007, using Windows XP Professional as my operating system. My laptop finally gave out, and I need to...

I have a strange problem with data being saved in excel spreadsheet. I've previously created an excel spreadsheet on a PC entered the data and saved it to our...

I have a spreadsheet with a variable number of data columns. The name of the column imported into the spreadsheet is located at the top of the column data. A...

The font size of the words in the drop down of the autofilter has changed, it is almost too small for me to read. How can I change the font size to a bigger...

Hey Everyone, I am creating a spreadsheet where I track data on a 90 day rolling basis. Here is the data I track "A,4+,T". How can I count the total numbers...

I have spreadsheets going easily from 16000 to 64000 lines, I used to make EXCEL 2003 charts by using 3-4 worksheets easily. They were big but ran very...

I have two worksheets, one with customer data and financial data, and a second with salesperson information. I need to "import" the salesperson from the...