Extracting and Consolidate Raw data from one sheet to another

[usama5788]

Hi, I am trying to find a more efficient process to get my huge raw data which I receive into my upload template. Please see attached worksheet.

As you can see I have given a little sample of my raw data. I then have to consolidate it to my Template Tab. I am trying to find a more excel driven process where it can fill all the information instead of me doing it manually. The four categories in the template are highlighted that is when the raw data is eventually goes to. Currently everything is done manually. I am trying find some sort of formula or better a vba code in which the “Upload template” can go into my “Raw data” tab and pick up the necessary information. Can anyone please help.

[queuesef]

...There's no need to fear.....Underdog (Pivot Tables) is here!!! Check out using a pivot table, you can then display data and if it's not to your liking, you can drag the data and PIVOT it (so if you don't want it in the ROW move it to the COLUMN area.

[usama5788]

I have thought about Pivot Table as well before. My main thing is to bring my Pivot Table data into my "Upload Template" tab. I trying to find a more optimize way so the data can populate in the "Orange" highlighted sections more efficiently rather than doing it manually employee by employee.

[queuesef]

You can format the Pivot table in a way to import data. see attached. Best of luck

[usama5788]

How were you able to format the Pivot table as your are doing now. I for some reason am not able to do it. Where you pull the Projects, DEPT ID in the Column B and C even though the Pivot Table is under the "ROWS"

[queuesef]

Once you are in the pivot table you'll need to highlight the 'Total Rows' you'll get an ARROW and then you can Right Click on pivot table and "REMOVE SUBTOTALs"....there will be a check mark next to it. When selecting the Total data, All of the other totals will be highlighted in blue, then right click and UNCHECK "Subtotal by....". Just a bit of manipulation. I also prefer "Clasic" Pivot table ( in Display Tab ~ better presentation for me.) Cheers

[usama5788]

I think I got the display to match yours now. THank you just a setting issue

[usama5788]

Now it just the struggle of getting a macro for this problem been struggling all day so far.

[queuesef]

You can always copy the Pivot Table to a STANDARD location, paste it in there and have a Macro Run from there. (It might even work better on Totals, but the word TOTAL will be in each row - may have to delete it. You can also check out DATA Subtotals....then you'll have to deal with the GROUPings. There a PITA (pain in the @ss) When one way doesn't work, try another. Good luck

[AliGW]

Rule 08: Cross-posting Without Links - YOU HAVE BEEN WARNED ABOUT THIS BEFORE

Your post does not comply with Rule 8 of our Forum RULES. Do not cross-post your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

No further help to be offered, please, until the OP has complied with this request.

[AliGW]

Infraction served for flouting the forum rules despite earlier warnings.

[queuesef]

Ali, I'm not sure what happened. I just came back from out of town. (not sure if this msg is private, but W/Ever). Did I do something? Please explain. THx