• 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. bobhc

    Cells showing numbers in WIndows OS but #### on Mac. How to fix this?

    Have you checked your column widths, poll removed.
  2. bobhc

    Search, Look Up, Find, Index from WBS

    @MyCon More importantly, what's the solution?...it may be important to you but not to the members who give their time for free and will offer help, if they can and when they have the time. In stead of demanding a solution you should read the forum rules where you would come across this...
  3. bobhc

    Is it possible to enter text in a cell & have it copy to another sht, even when cell changes?

    Enter your data in the main sheet, go to the sheet where you want to paste/copy. Select the cell where you want to place the copied data and in the formula bar insert the equals sigh, click on the sheet tab of your main data select the cell with data and press enter. Done
  4. bobhc

    how to autofill number 123 and 4 after merge cell in excel

    Please help...now that says a lot!!!!!! you would get more help and information from the oid East German police under Soviet rule.
  5. bobhc

    Index Match w/ Offset

    If you had taken just a moment to read the forum rules you would have read this bit, Never title your posts as "Urgent", "Priority" "Immediate". It may be Important to you, but not for rest of the members here. These words will be moderated out. Cross-Posting. Generally, it is considered poor...
  6. bobhc

    Not able to use Find command in vba,Please help

    If you had taken just a moment to read the forum rules you would have read this bit, Never title your posts as "Urgent", "Priority" "Immediate". It may be Important to you, but not for rest of the members here. These words will be moderated out. Cross-Posting. Generally, it is considered poor...
  7. bobhc

    26as

    I am sure that there will be members who think I have been curt and abrupt but if posters just took a moment to gather their thoughts as to what they need from forum members they would be able to formulate a post title that would attract the right help. And with members giving their time for...
  8. bobhc

    26as

    ...26as... As a post title this must be in the lead for the worst most non-descriptive title ever, if you had bothered to read the forum rules you would have read this:- How to get the Best Results at Chandoo.org Use Relevant words in the Title and in the tag Box, This will aid future...
  9. bobhc

    Connect Excel to Linux EZC files

    You really should be posting on a Linux form, this site is predominantly for Excel and the Windows PC environment.
  10. bobhc

    Modification of copy paste vba code

    Please use code tags as requested in the box just above where you enter your question.
  11. bobhc

    any help for this

    If you bothered to read the site rules you would have read this:- email address. Spam robots do trawl forums collecting this info. Abusive language will not be tolerated. Never title your posts as "Urgent", "Priority" "Immediate". It may be Important to you, but not for rest of the members...
  12. bobhc

    Sharing a workbook

    ....What options do I have ?....Very few. Excel was never designed to do what you want, users editing at the same time!! heart ache will ensue. Why do you need others to mess around with the pivot tables? For them to be able to enter data in to the raw data table should be enough and only by an...
  13. bobhc

    The A1 notation is an abomination that has no place within serious spreadsheet design -- discuss?

    Excel has more ways to skin a cat than needed, but the choices are there for the users, why restrict the options the only thing that should be consigned to the waste bin is the merge option.
  14. bobhc

    Think cell question

    If you think your problem is so important that you need to post on multiple forums then have the decency and manners to inform members of your actions, members are going to give their time for free to help you when you may have already received an answer on another forum, wasting their time...
  15. bobhc

    When you open the Excel file, you receive the error: "file Error: data may be lost. "

    Try here https://www.google.com/search?q=file+error+data+may+be+lost+excel+2003&ie=utf-8&oe=utf-8&client=firefox-b
  16. bobhc

    How to repair a corrupted ms excel file

    There are many differences between Excel and Open Office just altering the file extension does not mean one will work with a different set of trousers on.
  17. bobhc

    Macro: Column Sort with Merged Cells

    Avoid merging cells Merged cells can help you arrange values in a meaningful way, but they come with problems -- numerous problems, big problems. For instance, Excel won't apply column formats to a merged cell unless you select all the columns that comprise the merge. In addition, not all...
  18. bobhc

    How can i Draw a cross section in Autocad automatically with data in excel ??

    https://www.google.co.uk/search?q=impost+data+from+excel+into+autocad&ie=utf-8&oe=utf-8&client=firefox-b&gfe_rd=cr&dcr=0&ei=8f6sWrrNJu-JgAaM47TQDQ
  19. bobhc

    Paste data from outside Excel into merged cells

    Do not use merged cells, nothing but trouble and heart ache.
  20. bobhc

    Automated E Mail Notification

    A bit of light reading, knock yourself out...
  21. bobhc

    Conditional format color gradient on letters?

    Alpha do not hold a value as Numeric do so you can not CF as a value.
  22. bobhc

    Pivot Table with Text: How to View Data

    Why not use your data to make charts, pivots are there to work with numbers/data
Back
Top