Merging multiple sections of data to one table

Hi all,

I took this task to help someone thinking it would be 1,2,3. I thought this could be done with VLOOKUP, but it's not working the way it needs to. If it can be done without VBA be sure to let me know, but since I couldnt get it to work im under the impression that it cant.

There are multiple worksheets (6 i think), all with a certain section of data(list of names/titles/etc) that needs to be merged to a master list. Like so:

Please Login or Register  to view this content.

The master list needs to update as users add/delete data to the other sheets, and each sheet won't always have the same number of rows. Any ideas?

I guess this confirms it was more complicated than I thought, haha.

Thanks jaslake! There's a lot of personal information in this sheet so I mocked up something per your request. The merged worksheet shows the desired result (would usually be blank).

There is no other code to contend with. Thanks again.

Did some searching/tweaking. This is as close as I was able to get tonight:

Please Login or Register  to view this content.

That seems to grab what I want, but I can't get it to put it in the right place. It also will paste repeatedly vertically if you run it more than once, when it really should just paste the same info to the same spots over and over if you spam it. I tried changing the following to get it to paste to the correct spot:

Please Login or Register  to view this content.

But that only pastes Worksheet 6 (I assume because it is last)? Im probably just shooting in the dark here, not even sure if I am on the right track. Obviously new to this.

Looks perfect at first glance. I'll let you know if there are any issues when I get a chance to implement it live. Thanks!

Can't believe it was so complicated, I was half expecting someone to roll up and do it with a pivottable or something within minutes

Nevermind the above post, I just remade their spreadsheet around your code. Easy enough, and I may as well do some work rather than putting it all on you ;p

I ended up having to edit some of your code. There is some stuff underneath the bottom table in my live spreadsheet, so the second section of data was being pasted underneath THAT rather than in the correct location. Therefore I redefined LR as Range and mimic'd the code you used for rlast.

Please Login or Register  to view this content.

(you used this)

Please Login or Register  to view this content.

Is my method OK? It works fine now but I dont know if this will cause any unforeseen problems later. I assume there is a reason you did it the way you did. Thanks again man!

No sweat, it works perfect. Just wanted to pick your brain about the original method you used to help my learning process Wasn't sure if you had a reason for doing it two different ways for each table.

Thanks again, you're the man. I really appreciate the help. Cheers~