I have a format for clients' bills. The first sheet is in portrait mode. The remainder of the sheets are in landscape to allow for tables. The landscape sheets are printed with the head of the page on the right. I would prefer that they be printed with the head of the printed material on the...
I have been given response to a questionnaire in an Excel spreadsheet. There are 12 questions and 25 responses. Because the answers to any particular question range from a few words to a few hundred words, the sheet ends up with a lot of white space. I have tried several ways of formatting the...
I created a set of forms to use in creating bills for my clients. I use self-created Google Docs forms to keep up with my time, expenses, and receipts. When it is time to bill the client, I sort the time entries by client, copy and paste them to another form (created by me) in Excel 2010. I...
I read that Chandoo and his family moved to Wellington, New Zealand, in August. Has anyone heard if they are safe after the earthquakes in the last day or so?
I have employment data from a government employer with about 50 work sites. At each work site, there is a "Boss," sometimes an "assistant Boss," and several "Workers" (in the category I am analyzing). I have five years of data -- one year per sheet in each workbook.
In the Worker workbook, I...
I have a spreadsheet (by someone else) in which one column contains time entries in the format "3:15 PM." When I sort using this column, 3:15 PM appears before 8:00 AM. I tried setting the format of the column as "Time," but that seems to make no difference. I tried using TIMEVALUE(D2) to copy...
Sorry to ask so basic a question, but I am stumped.
A couple of years ago, I wrote a billing application for my law firm (an assistant and me) in Excel and later moved it to Google Docs (now Drive) with no changes that I can remember in the formulas. I have multiple clients (yea!) who are...
I have 39 Excel files (one sheet in each) that I want to combine into one large work sheet. All have the same columns. There are no formulas in the sheets.
Is there an easy way to combine all 39 into one sheet in Excel 2007?
A program (X) installed a macro on Excel to allow the two programs to communicate. I uninstalled X, but the macro remained. Now, each time I start Excel, there is a dialogue box from Microsoft Visual Basic. It says "Run-time error 53."
I have tried choosing "Debug" and deleting the macros that...
I am using Excel 2007 on Windows XP.
I have set up a billing template for my cases (I'm an attorney). Sheet 1 is the summary of the bill; sheet 2 is the receipts from the client since the last bill; sheet 3 is the time I spent on the case; and sheet 4 is the expenses. Formulas on the summary...
http://www.thedailybeast.com/blogs-and-stories/2010-12-27/microsoft-excel-the-programs-designer-reveals-the-secrets-behind-the-software-that-changed-the-world-25-years-ago/full/
In the Daily Beast.
I have created a VLOOKUP to retrieve an address from a worksheet (Source). In the Source Worksheet, the address was entered with a return (Alt-Enter) at the end of each line. The address can be 3 to 10 lines long.
If I copy this cell from Source to Target Worksheet, the formatting comes...