I would like to join two tables that have the same ids (one of the tables has less rows than the others, in the case of the missing rows I would like to have blanks)
I do not want to install a software on my computer for that...
Thank you!
2006-11-17 11:36:20 · 5 answers · asked by Anonymous in Computers & Internet ➔ Software
You don't need to install any software for doing this, rather, you just need to write a piece of VBA code to join the tables. If you are not sure how, send me your workbook at your_taurean@yahoo.com and I will help you write that code.
Also, add an example (by joining a few rows of the two table) to show what the joined result should look like.
2006-11-17 11:42:34 · answer #1 · answered by SmartSpider 4 · 0⤊ 1⤋
Do you mean by "tables" -- two Excel data files?
Do you mean by "IDs" -- headings?
I have "joined" Excel files by simply selecting all data in one file, copying, then pasting in the other. (You can go back and delete the data after the copy has been successful).
Of course you will need to do some moving of columns under the appropriate headings if the two files do not match.
2006-11-17 16:08:30 · answer #2 · answered by TheHumbleOne 7 · 0⤊ 0⤋
I dont think you even need to write code as their if afunction called VLOOKUP which will throw your data into corresponding cells, set up a column to add the data together then delete the cell with the source data ...easy. want to know more simon_sainteclaire@yahoo.com
2006-11-17 11:46:20 · answer #3 · answered by Anonymous · 0⤊ 0⤋
attempt this. go with column, click Paste, flow to sheet the position you want to position in, click Paste particular, Paste link. Repeat for different column, paste it in next column. in case you regulate the source cells, the outcomes will instruct on that sheet and different web page.
2016-11-29 05:50:48 · answer #4 · answered by Anonymous · 0⤊ 0⤋
Is at the right hand side of the Align Right button
2006-11-17 11:49:57 · answer #5 · answered by TLPreferBlue29 2 · 0⤊ 0⤋