• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. R

    Excel is ruining my life!

    Hi There, OK, so lets disregard Sheet 2 for now. Mine is Employee Detail and Sheet 1 is from the benefits company. They have to be merged so that when your looking across the sheet the right values are showing up for the right employees, and only common ground is their name. So it has to be...
  2. R

    Excel is ruining my life!

    Hi SirJB7, Its probably how i'm explaining sorry. As you can clearly tell, i'm not familiar with the Excel lingo. Ok, here it goes again. I have 2 sheets, one with internal values and one i get from our benefits providers site. The only similarity between the 2 sheets are employee names...
  3. R

    Excel is ruining my life!

    Hey There..... I think I kind of get what you did. However, if I'm trying to match employee name from Sheet 2 for an example, and copying data into Employee Detail sheet, and matching up the right employees, what would that look like? Employee Detail is what my reconcilation looks like, Sheet...
  4. R

    Excel is ruining my life!

    OK! Think i got it https://hotfile.com/dl/161677854/26f7885/Sample_file_RBC.xlsx.html I have deleted most of the employees and created fake names etc....but keep in mind this is for 500+ employees. So if i want to combine both work sheets and take data from sheet one and match it up with...
  5. R

    Excel is ruining my life!

    LOL! Funny Funny! How do I upload a file? I have a sample file created
  6. R

    Excel is ruining my life!

    Hi SirJB7! You've got quite the jokes....and yes, lets say its ruining half my life, to make you happy. I just came across the site today and will give it a look over and see if anything makes sense. When it comes to Excel, my mind does a "hard shutdown" and refuses to comprehend it...which...
  7. R

    Excel is ruining my life!

    @SirJB7.....its been ruining my life since the 15th....I have pending benefits reconcilations to do....and its all Excel based. We have running spreadsheets that we retain for historical data, so every month we get the new #'s and create a new spreadsheet....and then take benefits from RBC for...
  8. R

    Excel is ruining my life!

    Thank you for the quick response Luke! Good lord, i'm still lost. But let me see what I come up with. Thank you!!!
  9. R

    Excel is ruining my life!

    Hi Everyone.....hope this post comes out as technologically is out to ruin my life these days. Just got into a new position and it seems like i walked into a world of Excel...i mean i know the basics but never really used it. Now its ruining my life! Question: I have a list of my employees...
Back
Top