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...
Here is a second sample file--this one with data in the Description column. Download it, view it on the screen, then print it.
In case it makes any difference, I use an HP OfficeJet Pro 8720.
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...
AVK, The "Boss" data is on similar spreadsheets with the same format. I only sent one sample spreadsheets.
Thanks to everyone for the good suggestions.
I have attached a sample sheet with the payroll accounting data for the Workers. The Race Code and the Cost Center (the location) are the important ones. There is another sheet with almost the same structure, except that it has data for the Bosses.
An obvious solution I had overlooked is to put...
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...
Jason,
Thanks. That works on a new spreadsheet -- if I also set the format to 13:30. But it does not work on my existing spreadsheet. That means there is something peculiar about the formatting or something else in that spreadsheet.
Thanks to everyone who has suggestions.
Ed
I had tried setting the Time format to 13:30.
I just tried something else on a new spreadsheet. Column A is formatted for Text and Column B for Time (13:30) format.
If I enter 7:05 AM in A1, shouldn't =TEXT(A1,"TIME") in B2 display at 7:05? Instead it displays #VALUE!
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...
I am trying to create a new billing system for a friend and am copying my own system as the starting point. The sheet with the same formula does not work.
Ed
Thanks, Mike. I understand the VLOOKUP part, but the INDIRECT is confusing me. Shouldn't there be something in the formula that says "go to the Case page"?
Ed
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?
Hui,
I have tried that, but the TM macros (the now-deleted program was TM) are not on the list of Add-ins. I just figured out how to get the deletion to "stick" in the Visual Basic Editor.
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...
Luke,
I use the Adobe PDF "printer." Looking at its Properties, I don't see any setting that should cause a failure on the first print job of the day. But perhaps I should post a question on the Adobe board.
Ed
Hui,
Since the first page has a portrait orientation, and the remaining pages have landscape orientation, of course the Print Settings will be different.
But why does that make a difference one time out of, say, ten?
Ed
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.