Find string-value and add value in next cell

[Wintermaul]

Hi

Its a long time since ive been making macros but now i need one. I got 2 excel-documents. 1 document got the names, address and got a worksheet for each group of people and the other document got name and userID. I need to get the first document to also include userID in every worksheet.
Basically i want the macro to check the name-cells, copy the value of the cell next to the namecell which got the userID, and then find the correct name and add a new cell with userID next to it for every worksheet.

Ive got something on this guide: http://www.thespreadsheetguru.com/th...nd-replace-all
but its not good enough. Does it work to copy names and userID into a temporary array and use that for every worksheet? Or do i need to copy the nakes and userID into the excel-document and then run a new macro to compare names and then add userID when it finds similar names?
Can someone help? Is this possible?

[Mumps1]

Can you post a copy of both files? It would be easier to test suggested code on the actual data.

[Wintermaul]

http://www.filedropper.com/groups_3
http://www.filedropper.com/navnelisterrapport1

[Mumps1]

I have to go out for a few hours now. I will look at your files when I return and provide you with some feedback.

[Mumps1]

Place the following macro in a regular module in the 'groups' file and 'SaveAs' a macro-enabled file so that it's extension is changed to "xlsm". Next, make sure that both files are open and then run the macro.

Please Login or Register  to view this content.

[Wintermaul]

Thank you so much! This works perfect.

Im gonna ask for one more thing. Is there a way i could also combine the sheets in the group-file?
First run the macro. Then another macro to get 2-3 columns into 1 single worksheet. The original document has got very many sheets you see.

[Wintermaul]

Ive found this code on http://www.rondebruin.nl/win/s3/win002.htm but can get it to work correct. First i get error on "Last = LastRow(DestSh)" Not defined etc Then i ge anopther error for pasting in. Combined cells new same value.
And another thing, in the new sheet i want the title of the sheet whichs its copied from to get in a new row so i see where it gets it value from
)

Please Login or Register  to view this content.

[Mumps1]

Which columns from each sheet do you want to combine into one sheet?

[Wintermaul]

Which columns from each sheet do you want to combine into one sheet?

I need the names from G, and the number from I along with the name of the sheet. Doesnt matter if its more columns.
Actually got this code to work. But because of the format of the file its not 100%. Some columns look weird but basicly it gets the job done.

Please Login or Register  to view this content.

Along with functions

Please Login or Register  to view this content.

[Mumps1]

Try this macro:

Please Login or Register  to view this content.

[Wintermaul]

Thank you for your help! I was also wondering if i could get the value from cell B4 from each worksheet into the Summary-sheet for each line.
Ive tried something but the macro loops for each worksheet so i get the B4 value into the Summarysheet under column D but it doesnt copy the value.
I want it to copy the value for each row, not only for each worksheet. Hard to explain but i shortly i want the value of B4 in each worksheet beside the name of the worksheet in column D in the summary-sheet.
Is that possible or do i need a totally new macro which loops on a different value then worksheets?

[Mumps1]

I tried to download your files from the links you posted in Post# 3 but the links no longer work properly. I'm having a little trouble following what you would like to do. In your file, could you include a sample sheet that contains what you want the end result to look like?

[Wintermaul]

I tried to download your files from the links you posted in Post# 3 but the links no longer work properly. I'm having a little trouble following what you would like to do. In your file, could you include a sample sheet that contains what you want the end result to look like?

Ive sent you and private message but im gonna give you a image of how i want the Summary-sheet to look like in this post as well.
Excel.JPG

[Mumps1]

See if this works for you:

Please Login or Register  to view this content.