• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. estillbham

    Rotating sheets when printing

    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...
  2. estillbham

    Export survey's multiple-length text answers to more compact format

    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...
  3. estillbham

    Problem with printing a spreadsheet

    SirJB7, yes, the last column is excluded from printing.
  4. estillbham

    Problem with printing a spreadsheet

    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.
  5. estillbham

    Problem with printing a spreadsheet

    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...
  6. estillbham

    Pivot Table or something else?

    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.
  7. estillbham

    Pivot Table or something else?

    Chihiro, Thanks for your help.
  8. estillbham

    Pivot Table or something else?

    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...
  9. estillbham

    How is Chandoo after the earthquake?

    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?
  10. estillbham

    Pivot Table or something else?

    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...
  11. estillbham

    Changing AM and PM times into 24-hour format

    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
  12. estillbham

    Changing AM and PM times into 24-hour format

    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!
  13. estillbham

    Changing AM and PM times into 24-hour format

    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...
  14. estillbham

    How does this VLOOKUP formula work?

    I figured it out. The formula should have been =VLOOKUP(B2,Case!$B$1:$C$256,2,0) Google Docs apparently did not display the "Case!". Ed
  15. estillbham

    How does this VLOOKUP formula work?

    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
  16. estillbham

    How does this VLOOKUP formula work?

    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
  17. estillbham

    How does this VLOOKUP formula work?

    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...
  18. estillbham

    Combining 39 files into one

    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?
  19. estillbham

    Ridding Excel of a macro

    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.
  20. estillbham

    Ridding Excel of a macro

    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...
  21. estillbham

    Problem with printing a workbook

    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
  22. estillbham

    Problem with printing a workbook

    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
  23. estillbham

    Problem with printing a workbook

    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...
  24. estillbham

    Excel to Time Series generator

    I just ran across this awesome app: http://appsfordevelopment.challengepost.com/submissions/1506
  25. estillbham

    article on the origins of Excel

    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.
Back
Top