You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
-
tables and names
I know it’s a relatively old comment but there’s never a bad time for this. I wasted a couple hours last week hunting an error in my code, only to realise my agency-side colleague hadn’t updated the rows reference for a bunch of pivot tables built off my output. A couple years ago I started forcing myself to always make table before pivot, even if I don’t think I will reuse the file down the line.
stelfox
@Chalfie
Without wanting to sound like a "suck these eggs grandma" type, it's times like this when it's good to use tables and names.
Plonk all your data on sheet one
go to cell a1. press Ctrl+T. BINGO a table is created. TABLES ARE MAGICK.
you can rename the table by clicking the table design tab in the ribbon, there should be a little window called Table Name. Write data in there.
Then when you want to create a pivot you can insert pivot and write the word data in the range.
I don't understand why you've used a sheet 3. You could just use 2 more pivots but set the range to the dates?