Pivot tables

Neillaw
Neillaw New MemberRossendaleMAAT, AAT Licensed Accountant Posts: 283
Can anyone help me with this.
I have one table for invoices and another for credit notes, once I've copied the credit note file in with the invoices I'd like excel to automatically change the source data size to cover all the contents of the page.
Does anyone use this type of function.

Thanks
Neil

Comments

  • jul2614
    jul2614 Registered Posts: 9
    I'm not aware of a way to 'automatically' change the source data size, other than changing it yourself and then refreshing the data. I suppose you could write a macro (although I'm not very good at macros!) to get it to update the data size.
    Sorry I can't be much help
  • Adele69
    Adele69 CambridgeAAT Student Posts: 320
    I'm not really picturing the issue, though would agree like you say a macro assigned to a button could apply a consistent Font type and size to a worksheet in one click, or format painter would copy the format from an existing range to whatever else you want in the same style.
  • Neillaw
    Neillaw New Member RossendaleMAAT, AAT Licensed Accountant Posts: 283
    I have source data which takes up 100 rows, this is then copied over by source data of 110 rows.
    Can the source data be automatically adjusted from 100 to 110 rows.
  • MarieNoelle
    MarieNoelle Trusted Regular Hampshire/Surrey borderModerator, MAAT, AAT Licensed Accountant Posts: 1,433
    Instead of pasting over can you insert in your existing table then delete the unwanted rows?
Privacy Policy