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

    Data Entry and Pivot Table

    OK - now you are showing off! I'm impressed (albeit unable to fully follow what you have done). Problem is that I'm not sure I can properly maintain this once handed over to users to break.
  2. M

    Data Entry and Pivot Table

    Jeffrey - yes, in this report I do not aggregate data - I use the table to apply calcs to the downloaded data before using the pt to select the relevant lines of data by job.
  3. M

    Data Entry and Pivot Table

    Sage CRE 300 (Timberline) - ODBC link. The thread looks interesting - wasn't aware of this function. Thanks
  4. M

    Data Entry and Pivot Table

    Thanks for your responses. I suspect the answer is No but worth asking. I have attached example of sheet - I have removed the ODBC links but essentially project info is sourced from Accounting system on 2nd and 3rd sheets then presented in Pivot Table on first. Challenge is to then get...
  5. M

    Data Entry and Pivot Table

    Is there a way of appending a column to a pivot table which allows data to be typed in to it? I am downloading a Job Costing ledger in to Excel and analysing project performance using pivot table. This makes it easier for non-users of our accounting system to see project performance. The no. of...
Back
Top