Results 1 to 2 of 2

Thread: Upload Calendar

  1. #1
    New Lounger
    Join Date
    Jun 2009
    Thanked 0 Times in 0 Posts
    Hans, I need a pivot table to begin in cell J23-to sum payments by month-this calendar will update everytime we upload to sheet 1. Like you did previously, but your link was to WOPR. WOuld you please help me with this. Thanks.
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts
    You'll need to insert field names (column headers) into Sheet1!H1:I1, e.g. Date in H1 and Amount in I1. Otherwise you can' create a pivot table.
    Then select columns H and I (or a range in those columns), and create a pivot table.

    PS Please don't direct questions at me personally. I am just one of many active users here, and I can't be online all the time.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts