Consolidate and add value in next Row

[Mouctar]

Hi Everyone, Please find attached data and i am trying to create code that will do exactly in example in data attached. All i want in here is if employee pay pension contributions for 100 (Pen EE (Tal)) and employer pay for 200 on behalf of the same employee. Then, the worksheet should look like Colunm A= Pers No, Column B=Employee Name, Colunm C= ID Number, Column D=PenPay, Column E=Pens EE(Tal) and Column F=Pens ER(Tal) and G= Total (Pen EE +Pen ER values)

I hope this makes sense. i have tried several method for the pass 8 hrs but nothing. Thank you all for your help. Please see below attached

Data Download.xlsm

[SPARKY347]

Your data and the example provided makes sense. How do you want the "sample" sheet updated through a button? Or Change in data? Are the columns all lined up and labeled the way you want them? And can you provide the proper name for the consolidated data sheet other then sample?

[humdingaling]

would a pivot table not work?

[Mouctar]

Hello SPARKY347! Thank you for your help. If you could update the sheet through data that would be great. All the columns are lined up and labeled, as i want it. The correct name for data sheet is called Pension Splits.

Thank you again for your help

[Mouctar]

Hi humdingaling, Pivot table will not be able to do the lay out in the example in data attached.

[humdingaling]

on the pivot table
select only Mark and Dez and it will be exact same layout

anyway this aside
what happens with Lemon
whereby there are two different amounts for penpay?

[Mouctar]

Hello! thank you for your respond. In the example, the pivot table will not give the same result, as each Pen's need to be in different sheet or workbook. Pivot table give more work, as you need to manipulate the data to give the example lay out.

In the example, the Penpay value for EEs and ERS are not very much relevant but the most important thing is the example layout, how to pull cell data to match them.

Thanks again

[Zack Barresse]

Cross-posted:

http://www.vbaexpress.com/forum/show...58119&p=354337
http://www.mrexcel.com/forum/excel-q...-criteria.html

Please read: http://www.excelguru.ca/content.php?184

[FDibbins]

Zack Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost 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).

[FDibbins]

Zack Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost 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).

[Zack Barresse]

I'm not sure you've read all of the posts here FDibbins. This isn't my thread. I haven't cross-posted, but brought attention to the OP who did. I find it funny you linked to the same thread I have. As someone who helped create the information on that web page, I'm certainly humbled you would do so as a boilerplate reply.

[FDibbins]

Yikes, my sinsere apologies Zack, you are totally correct. That was meant to be directed at Mouctar.

[Zack Barresse]

No worries! I figured that was the intent. I've also posted in the respective threads listed and closed them there.

[Mouctar]

Hi all, I sincere apologies for my mistake and i am fairly new on these forum. I did not really mean to post it several places. Now i know the rules and promise not cross post again any thread without posting the link. You guys have helps me a lot since joining here and can only thank you.

Once again i am really sorry for any inconvenience this has caused.

Thank you

[FDibbins]

Mouctar, thanks for the understanding, and no inconvenience was caused

[Mouctar]

Hello! thank you all for your understanding. However, i am still waiting on for help regarding this post. As you know, i have posted in several place but all have been closed or ignored due to cross post. Any advise what should i do next or should i create new tread ?

Thank you

[Mouctar]

Hello! thank you all for your understanding. However, i am still waiting on for help regarding this post. As you know, i have posted in several place but all have been closed or ignored due to cross post. Any advise what should i do next or should i create new tread ?

Thank you