Pivot table 'format' that fills it self when data is pasted in to a sheet.

KVT Holland

New Member
May 10, 2017

I'm new to the pivot tables but they've already drove me crazy. I've been trying to make a format workbook where people can export data to.
This data gets 'translated' by the use of formulas in another sheet. The pivot table should then just read the translated data and fill the
pivot tables as they where on the original sheet.

- I've tried using a macro that would import the data and then give the range the name that the pivot was linked to and deleted the old one, but this would result in to it looking like the picture
- I've tried saving the translated data as chart, named range and copie as value (and tried as tekst).
- Copy the pivot in to another workbook that contained the data that worked in another sheet
- I've tried to macro an vba code the pivot to do what i want
- Even if i deleted all the data that was used and then pasted the exact same data back in to the same spot.

To be honest.... everything i dit resulted it in to looking like this and no way to make it look like it should. I was however able to adjust al the adresses
and names and then refresh the pivot tables. I tried making a macro that would swap the text in the data sheets with the data of the new sheet, but that
not a viable option due to to many variables.

This is how it should look (sort of)

I hope you guys can explain why the pivot table is so hard to drop new data on. and how i should approach this.
At this point i'm just temped to reproduce the data without the pivot table.

Kind regards,


Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...