Pivot tables
Neillaw
Registered Posts: 308 Dedicated contributor 🦉
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
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
0
Comments
-
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 help0 -
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.0
-
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.0 -
Instead of pasting over can you insert in your existing table then delete the unwanted rows?0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 317 NEW! Qualifications 2022
- 155 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 92 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 92 Software
- 274 Tax
- 136 Bookkeeping
- 7.2K General accounting discussion
- 201 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership