Extract pivot table data
I would like to find a way to copy the data from my pivot table into empty cells. For each MHxxxxx field I want the corresponding top 3 fields copied into cells. For example:
MH81711 has three sub fields: Russell, 18.104.22.168, 10th st. I would like to have MH81711 copied into A1, Russell into B1, 22.214.171.124 into C1, 10th into D1. Then loop through and find all the rest in the pivot table and copy into the next row. The number of fields are variable and there will not always be 3 for each MHxxxxx.
Is this possible? I have included a screen shot of what my pivot table looks like. The 126.96.36.199 number will be converted to text in the future, consider it a string like the other two.
If the output can be like this:
If someone has an idea or suggestion I'm all ears. Thank you very much for any help you can provide.
Re: Extract pivot table data
Right now I'm copying the entire pivot table and pasting values only on another sheet. I will attempt to do some loops to move the data around. If that works I'm good with it, I just hope there is an easier w
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By mir.mudassir in forum Excel General
Last Post: 02-02-2015, 09:44 PM
By zafirah in forum Excel Programming / VBA / Macros
Last Post: 05-31-2013, 11:49 AM
By Skipper Jones in forum Excel Programming / VBA / Macros
Last Post: 08-01-2012, 07:45 PM
By TomJoad in forum Excel General
Last Post: 01-14-2012, 10:37 AM
By trojan_kumar in forum Excel Programming / VBA / Macros
Last Post: 04-19-2005, 04:00 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1