Hello all!
I have problem what I need to solve. I have 2 worksheet, on every sheet is a table that I got from my colleague. They are both supervisiors, so on every table they putted own workers. How I can merge those 2 tables in one? I tried to use vlookup, but It not worked. Example file is attached. example.xls
Last edited by Denlahti; 02-11-2014 at 02:13 AM.
I think you have to call it as TABLE instead of CHARTS.
Can you please show the expected result?
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Sorry. So, I want that in the new table will be names, City, Title, Age(yes, I know tha age is mission from second table) and idnum from both tables. This example is verry simple in real I have more info.
Please show it in excel
Okay. Something like thisOriginally Posted by :) Sixthsense :)
Please show it in excel
Last edited by Denlahti; 02-07-2014 at 05:37 AM.
Hi Denlahti,
Try this:
Directions for running the routine(s) just supplied
Please Login or Register to view this content.
Copy the code to the clipboard
Open your Workbook
Save your Workbook or Another Workbook designated for Macros as Macro_Enabled
Press ALT + F11 to open the Visual Basic Editor.
Select “Module” from the Insert menu
Type "Option Explicit" then paste the code under it
With the cursor between Sub and End Sub press F5 (F8 to Single Step)
OR
Press ALT + Q to close the code window.
Press ALT + F8 then double click on the macro name
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Thank you very much xladept. But macros are not familiar to me. Can you please tell me how I can use that macro? So every think worked fine. Arter that last spet I didn't got any error.
-Thanks I worked this out
Last edited by Denlahti; 02-10-2014 at 02:50 AM.
Now I have other guestion. What I want to use this marco in other document. What I need to change in that code?
Maybe something like this? Pleasee check the file, hope it works
That is pretty good, but it don't search all IDnumbers...
In another document you need to change the items colored red:
Please Login or Register to view this content.
Denlahti are you trying to do the same thing with no ID number in the record? If so, then I need another example Spreadsheet.
Thanks xladept. This will be enought. Thanks for your great codeIn another document you need to change the items colored red:
Please Login or Register to view this content.
You're welcome! And, thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks